If Sum Then Statement

Question

Hi,

I need help with the below formula, where I want to add the rows of one column in the if-else condition. I highlighted where I am facing issues.

IF Column1=column2 AND column3="New" AND column4="Yes" AND Sum(column5)>=0 THEN "True" ELSE "False" ENDIF

Qiu · Answer

@priyankabnl 
I noticed that you have a Sum operation in the IF statement, but unfortunetly we can not do Sum Operation in a Formula Tool.
I tried with a Summarize Tool then bring back the Sum back to the original data stream.

Hope this works for you.

0927-priyankabnl.yxmd

Emil_Kos · Answer

Hi @priyankabnl,

If your column 5 is in numeric format you just need to write:

IF Column1=column2 AND column3="New" AND column4="Yes" AND column5>=0 THEN "True" ELSE "False" ENDIF