Find problem w/calculated field including relation

[Edward Newman]

Ok, someone tell me I am not losing my mind! I have a solution, developed in 4, migrated to 5 and now 7. One of my reports is now not working and I am trying to fix it. The report has a find critera that searchs for "Balance" > 0. "Balance" is a calculated field set to ( "Sell Price" - "Invoice Total" ). Both "Sell Price" and "Invoice Total" are related fields. In browse mode, when "Sell Price" and "Invoice Total" are the same, "Balance" shows as 0. This is good. The problem is when I do a search, either manual or from a script of "Balance" > 0. It returns tons of records where "Balance" shows as 0. To make it worse, when I search on "Balance" = 0, I get some of the records that are zero and some that are not! Is this a problem with searching on calulated field with related fields in their calculations? Please tell me I am not crazy. This worked fine in v5

[QuinTech]

Hi, Edward. First step, check that Balance is a number field and not a text field.

HTH,

Jerry