If and statement issue

[JagjeetSingh]

I am trying to use the if and statement and getting error in the formula. can I get help on the following formula. 

IF ([Product_key]=11 AND [reporting_date]=[Ndate] and [Product2]='Retail' AND [WEIGHTED_STG]=1) THEN 'RV1'
ELSE 'test' ENDIF

[IraWatt]

Hey @JagjeetSingh,

Your IF syntax looks fine. You will be getting this error due to incorrect data types. This is where you for instance you compare a text column to a number column. Can you share some example data?

Just guessing where the error is but I would check  [reporting_date] and [Ndate] are the same data type.

Any questions or issues please ask :)
HTH!
Ira

[PhilipMannering]

What's the error?

[JagjeetSingh]

thanks for your response, I found the issue it is with the data type and I and found a solution for that too.