Group footer subtotal rounding problem
I got a group band eg. displaying sales price, quantity and the percentage
price of the unit price:
OrderNo Item Price Qty 20% of price
1 Nail 2.25 1 0.45
2 Pin 3.32 1 0.66 (acutally is 0.664)
3 Glue 3.32 1 0.66 (acutally is 0.664)
Subttotal: 1.78
The subtotal is actually correct: 1.78. (round 1.778 to 1.78)
However, the report subtotal should be 0.45+0.66+0.66 = 1.77.
How do I get around the subtotal only shows the sum of display figures?
price of the unit price:
OrderNo Item Price Qty 20% of price
1 Nail 2.25 1 0.45
2 Pin 3.32 1 0.66 (acutally is 0.664)
3 Glue 3.32 1 0.66 (acutally is 0.664)
Subttotal: 1.78
The subtotal is actually correct: 1.78. (round 1.778 to 1.78)
However, the report subtotal should be 0.45+0.66+0.66 = 1.77.
How do I get around the subtotal only shows the sum of display figures?
This discussion has been closed.
Comments
OnCalc event, simply add the rounded value to the existing value to keep
track of the total.
Value := Value + RoundTo(Report.Datapipeline['Price'] * 0.2, -2);
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com