Search REcords Criteria Value of a Calculation field not working
My Table has the following fields - InvoiceId, ToTal Amount, Payment, PaymentDate,Balance. Balance is a calculation field ( ToTalAmount - Sum(Payment),
I am trying to create a report that displays all those invoices where balance is >0. My Find criteria is Balance>0. However this does not give correct results - I see some records where the balance is 0, some records where the balance is -ve and some records where balance is >0.
How do I fix this.