subsummary mental block

[GlennC]

Thanks Stephen for such a speedy resonse creating this topic in the forums.

I can't for the life of me figure out how to get a count of the number of groups in a subsummary, which is a count of the field that is used as the break field. To make my meaning clear, the example FM uses in the help files is a subsummary report of sales figures summarised by geographical regions A, B, C and D.

In this example, as well as the summaries I would need a count of the number of regions the report found (ie 4 in this example).

I have created a summary 'count' field for this field, but this gives me the count of every record in the report, not the count of the different regions.

I hope this is clear enough. All help greatly appreciated.

Thanks,

Glenn

[jscooper]

Easiest way I've found to get a distinct count is to make a value list based on the field you're counting. Then make a calculation like this:

distinctcount = patterncount(valuelistitems(status(currentfilename),"myvaluelist"),"

[GlennC]

Thanks very much Jeff, I'll have a go at it.