Sum / Count Problem

[dajamle]

Hi,

First off, I'm just starting with Filemaker, so I apologise if I sound an idiot .

Anyway, I was wondering if it was possible to define a field where it counts the number of fields that have a certain value in them. It's basically a "Sum" function, but I need it to count how many records have the number "1" in a given field. I've played around a bit, but not been able to get very far with it unfortunatley.

Any help you guys could give me would be very much appreciated.

[dkemme]

Here's an example, I created a global number that is the match to look for, a calculation that is 1 if matches and 0 if not, and then a summary field that sums the calculation field. You can change the global value to sum up another number to match.

Cheers

DJK

[aaa]

Use Performe Find, then Count() function

[dajamle]

Thanks a lot guys, I'll try dkemme's idea, as I think I can interpret that as needed. To aaa, thanks for your reply, but I was hoping I could utilise it in define fields rather than a script.

*Edit*

Just to say that it worked great, thanks for you help.