In the report I have a sub-grouping total based off a conditional test.
The control source for Text91 is =IIF(Sum([AmtDue])>10, Sum([AmtDue]),0)
The Text91 sub-total is working fine and doing exactly what it is supposed. However, I need a "Grand Total" at the bottom (Report Footer).
Right now the Grand Total is [Text104]
The control source is = Sum([Text91])
Which should add up all the individual sub-totals. When I run the report I get a pop-up window asking me to input a value for [Text91]. This error is ocurring at the footer level. How can I get a grand total in the report footer based on the sub-totals contained in the section footers?