Have you considered what the "@" might be doing in your case statement? Email add's would all have the symbol and it is a special character for some FM functions (like find for example).
Try taking the @ out of some of the emails and see if they disappear from your error list. If you confirm that that is the issue, post up your case statement and we'll see if we can't work around the problem.
If that doesn't work, you can post the actual calculation here so others can take a look at it.
Case (EMAIL = ""; "";
EMAIL > "" and not (EmailAddedDate > Date(1;1;1)); "Email has not been added.";
EMAIL > "" and not PatternCount (EMAIL;"@"); "Email missing ampersand";
EMAIL > "" and Count (Prospects by emails::EMAIL) > 1; "Duplicate Email";
LAST NAME > "" and Count (Prospects by Name::LAST NAME) > 1 and not (notaDupe > ""); "Duplicate LastName";
yeah, looks like i am trying to handle the ampersand so who knows what it is really testing. but i can't see either cause it results in blank :(
Actually & is called an Ampersand, not that it matters here :smileywink:
There's some tricks you can use to simplify your case statement:
Case (IsEmpty(Email) ; "";
IsEmpty (EmailAddedDate); "Email has not been added.";
not PatternCount (EMAIL;"@"); "Email missing ampersand";
Count (Prospects by emails::EMAIL) > 1; "Duplicate Email";
Not IsEmpty ( LAST NAME ) and Count (Prospects by Name::LAST NAME) > 1 and IsEmpty (notaDupe); "Duplicate LastName";
The @ shouldn't be a problem here. That's an issue if you try to find fields containing that special symbol, but that's not what you are doing here.
"when i do a find with * in this field, it finds all records that have text in a particular text field, but when I examine that calc field there is nothing in there."
That really sounds like your calculation's result type is set to "number" instead of "text". What happens when you click in the calc field? Does text appear?