Hi Community,
I have a report that is showing the lines of an Invoice grouped by AR Tran Reference Number.



The problem above is that the total report Margin % is not calculating correctly, even though everything else is calculating correctly. It seems it is just grabbing the first Invoice Group % and bringing it down. Anyone know why?
The Formulas I used in the GroupFooterSection1 and ReportFooterSection1 are all identical, and all of the values calculate correctly except for this one below for the report Margin %.

Thanks,
RJ