conditional statem

[Hi2023]

I am trying to create this in a formula and for some reason it is not working? help plz

if “Account Number” on input file is equal to “2023” / “2021” put data from “Card #” (input file) in this field

I tried 

IF [ACCOUNT #] IN ('2023','2021') then
[card] ELSE Null() ENDIF

I tried a couple others but really like insight.

thanks

[cjaneczko]

I believe you have to convert the account number to a String in order for it to work as you have it typed above. Just tried it with sample Data and it works. 

[binuacs · Accepted solution]

@Hi2023 check your data type of the field ACCOUNT#, if it is numeric then remove the quotes from the formula 

IF [ACCOUNT #] IN (2022,2021) then
[card] ELSE Null() ENDIF