I'm creating a Profit and Loss statement. I have a running total that gives me my gross sales. I have Totals for each sales account and I have to give the percent of that total compared to the Gross amount.
Example of what I'm trying to do:
(GroupFooter3) Sales 101 $100 25%
(GroupFooter3) Sales 201 $200 50%
(GroupFooter3) Sales 301 $100 25%
(GroupFooter1) Gross Sales $400 (Running total)
This is what I'm getting:
(GroupFooter3) Sales 101 $100 100%
(GroupFooter3) Sales 201 $200 66%
(GroupFooter3) Sales 301 $100 25%
(GroupFooter1) Gross Sales $400 (Running total)
When I try and do a formula it uses the value of the running total at the detail line that its on and not the grand total. Reason I used the running total is I am selecting specific records to add from a detail section.
IP Logged
