### Title

Search REcords Criteria Value of a Calculation field not working

### Post

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.

Thanks

Dee

What hardware and software are you using to post messages to this forum? Your post includes some weird text in it and we may need to bring this to the attention of ModMan--our forum moderator so that he can contact the RightNow team over at Oracle and let them know that there's a probelm.

Sum (Payment) in this context will return exactly the same result as just Payment and you could rewrite your calculation for balance to be:

TotalAmount - Payment

And get the same result.

I'd check your result type in the Balance calcualtion. It should specify Number. If Text is selected, the calculation will appear to work, but searches and finds on this field will not.