Can you calculate using sub-summary data?

[GC GYM]

Hi there all,

In a payroll table, each record is a shift worked. Earnings = pay rate * hrs worked.

I have a sub-total (Gross Wages Due) appearing in a sub-summary part which is a total of Earnings. Next to it I want to use a calculation to show the tax due on Gross Wages.

The tax must be calculated on the Gross wages, it cannot be calculated on each record's Earnings then shown as a sub-total itself.

Is this possible because putting the Summary field in a calc to work out tax due doesn't work?

Hope that made sense?

[comment]

Try the GetSummary() function.

[GC GYM]

Thanks again Comment