I am trying to get the following formula to work
IF FEE > 0 THEN ROW COUNT
I have tried this:- ((Number of Records > 0) AND (Fee Amount <> 0)) * Number of Records
(Fee Amount > 0) * Number of Records
What I am trying to do is count the number of records where there is a fee amount.
But the first one only ever returns all the records and the second one only ever returns 1.
Any help much appreciated.