Counting records with certain values (value lists)

[lownoma925]

I'm having a problem figuring out how to have my status indicator break down how many records are in "status a" and how many are in "status b" on a report. I'm trying to eliminate having to search all the time. I want to know everything at a glance. How hard would it be to do in FMP5? Everything is on one table right now.

[Inky Phil]

Assuming that 'status' is a field then one way would be to use relationships and the Count()function.

Create a global field 'G_match'. Create a relationship between match and status. Call this relationship 'stat_count'

Create another field called stat_total. Set it to be an unstored calc field with the formula Count(statcount::anyfield that def.isn't empty).

If you now set G_match to 'a', stat_total will show you the number of status a's that you have. If you change G_match to 'b' stat_total will display the number of records that have 'b' in them.

If you want to see both at once you will have to repeat the same process with another global another relationship and another calc field then set one global to 'a' and one to 'b'

This might all seem a bit clinky but it will work in 5 as well.

HTH

Phil

Edited December 4, 2006 by Guest

[lownoma925]

Do I have to create a new file or can I relate it using the same file?

[Inky Phil]

You can use the same file

Phil

[PaddyO]

If I needed to do something similar in FMP8.5 would I need the same calcs?

Here is my original post.

http://fmforums.com/forum/showtopic.php?tid/183266/post/234221/hl//

Edited December 29, 2006 by Guest