AnsweredAssumed Answered

Testing for Zero

Question asked by PatriciaSamuelsen on Jul 26, 2013
Latest reply on Jul 27, 2013 by philmodjunk


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?