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