In my report, I want to calculate the %Sale value.
For that, I need to divide Sale by Total of Sales.
The problem is when each row is printing the total
of sales is not completly calculated. How can I do
that? Does I need to calculate it before printing?
Description Qty Sale %Sale
------------ ----- --------- ---------
Product 1 200 $5000.00 50.00
Product 2 150 $2000.00 20.00
Product 3 150 $3000.00 30.00
TOTAL 500 $10000.00 100.00
Thank you for your help.