Hi! Just a quick question, it seems exceedingly basic but I cannot find anything from searching the community.
Basically, I have a formula tool that creates a new Column. If the relevant fields of the incoming data [Sum_Cash Amt], [Sum_Revenue Amt], and [Sum_GST_IN Amt] is true in the following fashion:
-[Sum_Cash Amt] = [Sum_Revenue Amt] + [Sum_GST_IN Amt]
OR
[Sum_Cash Amt] + [Sum_Revenue Amt] + [Sum_GST_IN Amt] = 0
Then for that row, I want it to return "Risk Criteria 1"
However, I cannot get either to work (only need one of the above, so no need for an actual OR formula, methinks). Even when I export into excel and add up the fields, they equal zero. However, the formula returns a null, as per the formula below:
If -[Sum_Cash Amt] = [Sum_Revenue Amt] + [Sum_GST_IN Amt] Then "Risk Criteria 1" Else null() EndIf
I would not expect this to be the case, and hence am confused why it is not returning "Risk Criteria 1" for most of the rows. For an example, see Row 13 of the formula tool's output - although the figures add together to be nil/equal, "Risk Criteria 1" has not been returned.
Thanks!
