Looping through GetSummary Values

[Digital Life]

I have a nice report that shows revenue broken out by revenue code:

Meals $1,289.00

TV $42.00

Internet $80.00

etc.

The totals are calculated using a Summary field which adds up all the revenue for each revenue code.

What I want to do is grab the total for each of the different lines and move it into a variable. I am using the GetSummary(Revenue;RevenueCode) calculation.

It works fine for the first line but it does not appear possible to go to the next line to extract the $42.00 amount. I just keep on getting the first value.

I suspect that even though I do not have the details showing, just the summaries, that behind the scenes FM is still going from detail record to detail record.

Is there a way to isolate the 3 summarized values?

[comment]

It works fine for the first line but it does not appear possible to go to the next line to extract the $42.00 amount.

You have to jump to the first record in the "TV" group. This can be done by defining another summary field as Count of [any field that cannot be empty]. Then go to record number =

Get (RecordNumber) + GetSummary ( sCount ; RevenueCode )

[Digital Life]

That's got it. Thanks man!