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
Solved! Go to 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
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.
Spot on... thanks a million for a very quick reply