I have a sales report by salesman and customer.
Sales Cost GP %of Total
Joe Salesman
1. Customer 1 2.00 .50 1.50 33.3%
2. Customer 2 5.00 2.00 3.00 66.6%
Totals for Joe 7.00 2.50 4.50
Sales and Cost are running totals using a formula (because I have two subreports with shared variables). The GP is a calc of the running totals display (sales-cost).
% of Total is the GP for the customer/Joes total GP.
What my report is producing is 100% (rather than 33.3) and 66.6%. For Customer 1 is sees Joes total GP as 1.5, not 4.5.
I'm assuming it's the running total formula.
How do I fix this?
Sales Cost GP %of Total
Joe Salesman
1. Customer 1 2.00 .50 1.50 33.3%
2. Customer 2 5.00 2.00 3.00 66.6%
Totals for Joe 7.00 2.50 4.50
Sales and Cost are running totals using a formula (because I have two subreports with shared variables). The GP is a calc of the running totals display (sales-cost).
% of Total is the GP for the customer/Joes total GP.
What my report is producing is 100% (rather than 33.3) and 66.6%. For Customer 1 is sees Joes total GP as 1.5, not 4.5.
I'm assuming it's the running total formula.
How do I fix this?