Calculate Grand Totals on Visble amounts

[crystalfun]

I have a report that shows total cost per group only if the total is > than $100K. If the total is less than $100K than all the groups costs are hidden


The Grand Total in the Report Footer section shows the total of all visible and hidden amounts. Is there a way to calculate the grand total on visible group totals only?

My group total is calculated as follows: =Sum([Balance])

 

[dhookom]

You could try a control source of:
=Abs(Sum([Balance]>100000 * [Balance]))

Duane
MS Access MVP