Need help in formula

Question

Hi,

Please let me know what is wrong in below formula

IF [P_PRODUCT_ID] IN ("1805","1802") THEN "Y" ELSE "N" ENDIF

Thanks in advance

martinding · Accepted Answer

Hi @Mohini79 ,

What is the error message you are getting?

danilang · Accepted Answer

Hi @Mohini79

Check the field type of the [P_Product_ID].  If it's a numeric field, remove the quotes from your In clause [P_PRODUCT_ID] IN (1805,1802)

Dan

gaoa · Accepted Answer

Hi @Mohini79 agree with @danilang

* If [P_PRODUCT_ID] is a numeric field then formula should be: IF [P_PRODUCT_ID] IN (1805, 1802) THEN "Y" ELSE "N" ENDIF
* If [P_PRODUCT_ID] is a string field then use datacleansing tool to remove extra spaces or trim unwanted characters in the field.