Counting from list field

[Matteo]

Hi all,

My problem is the following:

I have a field which is related to a list made of three items let's say "past", "actual" and "future".

I'd like to count the number of record where "Past" is selected, as well as the number of record where "actual" is selected etc...

Could someone help me ?

Thanks

Matteo

[Matteo]

Sorry I just got my answer....

Create a field for each value (past, actual and future) and count using patterncount ( FieldList, "past").

Then display the total using a summary field = Total of (patternCount(...))

Sorry for disturbing...

[LaRetta]

Never disturbing ... that's what Forums is for.

If you create a summary field (number) of Count(checkboxField) then:

Create a columnar report with sub-totals. Select the checkbox field. Group by checkbox field and sort by the checkbox field. Let FM store the script for you because sort order is important. Delete the body of the report. Place the summary field in the leading part next to the checkbox field.

Perform a manual find thus:

"past"

New Find Request

"actual"

Perform Find []

Then modify your script so it looks like this:

Go To Layout [ new report ]

Enter Find Mode [ uncheck pause, check Restore ]

Sort [ Restore ; No dialog ]

Enter Preview Mode [ pause ]

Enter Browse Mode [ ]

Go To Layout [ original layout ]

When you leave Script Maker, select REPLACE to store this new find within your script. Now this report will do it all for you automatically and additional fields are unnecessary. Sometimes this is useful; sometimes you need a calc field to always display your results.

The added benefit of reporting is that the checkbox fields don't have to be hard-coded. If you later add another category, you'll always be adding fields ... with Restored Find, you can simply modify your find requests. And this will adjust if you want to restrict by dates as well - just include them in your search criteria.

LaRetta