Skip to Content
0
Aug 24, 2023 at 05:26 PM

Grp & Rpt Sums used for % Calc not giving same total...

62 Views

I have a CR2013 report design that has the following sections: Report Header, Group #1 {Customer}, Detail (suppressed), Group #1 Footer, and Report Footer.

Detail Section has {InvoicedAmount}, {PaidAmount}, {CostTotal}

  • Grp #1 Footer has the following columns:
  • Sum({InvoicedAmount}, Customer)
  • Sum({PaidAmount}, Customer)
  • Sum({CostTotal}, Customer)
  • @%Paid = ((Sum({PaidAmount}, Customer) / Sum({InvoicedAmount}, Customer))/100
  • @ExposedAmnt = Sum({CostTotal}, Customer) * @%Paid.

But, If I manually add up the Group #1 amounts for @ExposedAmnt, they don't equal the report footer formula for the same. I think this is because I have to "recreate" the @ExposedAmnt and @%Paid formulas in the Report Footer which gives me a different % value and a different @ExposedAmnt Value for the Report Footer. So my question is this: How can I get a Group formula to total down (sum) for all the group values above added together?

Thanks