Count Function

[treinoza]

Hi,

I'm fairly new to FMP and I'm trying to figure out the Count function. I have a field named status that contains 5 options from a value list.

What I need to know is a Count of how many times status=Available. Can you help me with the syntax? The function library lists it as:

Count ( field {; field...} )

This information will be stored in a calculation field named Prints Available.

Thank you!

Tatiana

[mr_vodka]

It would be easy to get the results by using a summary report, but since you want it in a calculation field, you may want to take a look at this post.

Count Checked Boxes

[treinoza]

Thank you, John. The Count Checked Boxes post is exactly what I needed.

Have a great day!

Tatiana