Testing for Zero
I have an calculated account balance field. This is the calculation: Round ( TotalFees - Payments::DepositTotal ; 2 )
When the account balance is zero, the field displays: $0.00
I need to test it for zero, but I get no records found when I use this criteria: =0
I even tried "=0.00" and it still didn't work.
If I use "<.01" it does work.
Unfortunately, I need to be able to exclude negative balances (refunds) and positive balances (unpaid) so I really need to be able to actually test for zero.
Anyone know what the problem might be?