Need help counting certain records

[Lhogan]

I was not sure where to put this question and I am sorry if it is the wrong spot.

I have about 500 records and each record is a different job. Each job has a Job Status drop down that is linked to a value list. (Not Started, In Progress, Installed, Completed, F.L.O.S) The field is named WorkOrder::JobStatus

I would like to have kind of a reports page that people can go and see a total number of each.

I tried creating new calculation field with the following: from WorkOrder, = ValueCount ( FilterValues ( List ( JobStatus ) ; "Installed" ) )

With this I always get either a 1 or a 0.

Any ideas would be great. Thanks!

Edited February 24, 2010 by Guest

[mr_vodka]

Just create a subsummary report grouped by JobStatus.

[Lhogan]

I did that and added a count field and it kinda did what I needed it to do, but I have to be in preview mode for it to work. Is there a way to have a calculation in a field do the same thing?

That way I could have a separate field for each category.

Ultimately what I am looking for is just 5 fields to be displayed.

So it will look something like this:

Not Started 1

Installed 10

In Progress 20

Completed 132

F.L.O.S 13

I dont need fields from every record to be displayed just a count of each. That was my fault I was not very clear in my first post.

[mr_vodka]

GetSummary().

BTW starting from FMP10 you can have subsummaries in browse mode in case you upgrade.