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.
My Table has the following fields - InvoiceId, ToTal Amount, Payment, PaymentDate,Balance. Balance is a calculation field ( ToTalAmount - Sum(Payment)
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.
Using mac book and safariPreferencesPreferencesPreferencesPreferences
The Balance is a calculation field and the result is a number. However when I do the search in a list view I do not the appropriate resultsPreferencesPreferences
Hmm, with such a common choice of platform and browser, I'm suprised we are seeing this result in terms of the odd text that is inserted into each of your posts.
Please post an example of the data you have, the search criteria you are using and the results you are getting when you "do not get appropriate results".