Help with IF formula

[rdeshpande]

Hello, could you please help me understand what is wrong here? Thank you in advance

IF [Brand] = "A01" AND [Material] IN ("SGE68X55UC","SGE78B55UC","SGV68U53UC","SGV78B53UC","SGX68U55UC","SGX78B55UC","SGE53B52UC","SGE53B55UC","SGE53B56UC","SGE53X52UC","SGE53X55UC","
SGE53X56UC")
THEN "xxx"
ELSE "yyy"
ENDIF

[KarolinaRoza · Accepted solution]

hi @rdeshpande 

I think it is due to NUMERIC data type of column Band, and you try to compare it with string value.

Your formula will work if you apply tostring() function:

IF tostring([Brand]) = "A01" AND [Material] IN ("SGE68X55UC","SGE78B55UC","SGV68U53UC","SGV78B53UC","SGX68U55UC","SGX78B55UC","SGE53B52UC","SGE53B55UC","SGE53B56UC","SGE53X52UC","SGE53X55UC","
SGE53X56UC")
THEN "xxx"
ELSE "yyy"
ENDIF

Regards,

Karolina

[Emil_Kos]

Hi @rdeshpande,

@KarolinaRoza is right. I am assuming that you don't have A01 in values for Brand column. I would suggest changing this to string(using the select tool) if you expect to have a string value in there. 

[rdeshpande]

Spot on... thanks a million for a very quick reply