If Sum Then Statement

[priyankabnl]

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

[Emil_Kos]

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

[Qiu]

@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.