Checkout this file. There is a bug in the Summary field "Count of" illustrated in this file. I hope Filemaker fixes this soon!!!!

Count_Problems.fp7.zip

Have you submited it to Filemaker. If not, go here Link

Steve

Seems to be a problem with the text you are counting.

If the characters in the field to be counted has one or more numbers followed by an "E", followed by a number greater than 00799, the record is not counted. Using a different letter, or more letters, or no leading number, the problem does not happen.

Even though the field is defined as text, perhaps it is somehow seeing a number in scientific notation that's too big to deal with, so it doesn't evaluate it.

Yes, I have submitted this as a bug. And I am aware of many ways of changing the text to get it to work, but the point is it should work in ALL these cases...thus it is a bug.