I have a lot of pairs of Debit and Credit columns like so:
I want to find the unusual and usual ones, with the condition that:
- if ANY the Dr >0 AND the Cr >0, then Usual, else Unusual.
So my formula tool is like this:
I don't think there's anything wrong with the logic in the Formula tool? But I don't understand why the results would all be unusual, when in the screenshot above, all of the first four rows should have been usual because Dr 76>0 and Cr 76>0
When I tried using a sample data using text input, it works fine:
Why is Formula tool giving incorrect results when I'm using my original data? What's happening?
