AnsweredAssumed Answered

Calc resulting in incorrect results

Question asked by dataWolf on Aug 5, 2010
Latest reply on Aug 6, 2010 by sunmoonstar.13

Title

Calc resulting in incorrect results

Post

I want to find duplicates in a file so I self-reference my Prospects file with two relationships, one via two indexed text fields of names, and the other via one indexed text field of email. Then I calculate errors. 

Case (

Count (Prospects by Name::LAST NAME) > 1 and (DupeOkay = ""); "Duplicate LastName"; 

Count (Prospects by emails::EMAIL) > 1; "Duplicate Email";"")

When I find for records with text in Error calc, I get back a set that includes some records that shouldn't be there and don't have text in error. They are dupes but have had the DupeOkay field checkmarked (they are same name but not same address, not true dupes). So if they DIDN'T have DupesOkay they should have Error and show in found set, but they ARE stamped so they DON"T have error but DO appear in found set (as though they do).

Using FMP9, Error field is not stored, of type text, do not calc if empty.

I just Recovered the file to see if rebuilding the indexes would help but it did not. The file is being served by FMServer11

I also tried not (DupeOkay > "") with the same results and IsEmpty (DupeOkay) with worse results.

Ideas?

Outcomes