Counting the number of markets...

[Niet32]

I haven't been able to find an easy answer for this problem:

If I have 1000 records that contain info for 33 markets and when I have a layout that includes summary functions and I want to know how many markets a certain brand has how do I get it to show 33 rather than the actual number of records, like 345?

Thanks

[-Queue-]

If you are previewing/printing this layout and using a subsummary part, just use a summary field that is a count of your market id. Then, sort by market id and you should see the correct results in Preview Mode and when printing.

If you want to see this in Browse Mode, create a calculation of GetSummary( summaryfield; market id ) and make sure your found set is sorted by market id.

[Niet32]

QUEUE:

Thanks for the response. That's the problem when you do a count it counts all the records with the same name as the market.

I might not have been clear. If I have Cleveland as a market and there are 100 records with Cleveland and when I want to know if Cleveland is being reported, how do I get it to report Cleveland as 1 market rather than 100?

[-Queue-]

Try 1 / GetSummary( summaryfield; market id ) and then create a summary field based on the total of this calculation.