Skip to Content
0
Nov 17, 2010 at 09:25 AM

Help required with IF THEN FORMULA

13 Views

Hi All,

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

Also tried

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

Thanks

Craig