Rounding of a total with a percent calculation

[Former Member]

Post Author: jdomkus

CA Forum: Formula

I have a sales field that is taking .10 of the total and placing that total into a new field. This figure is then being used in a total calculation with other values. My problem is the calculation is not being handled correctly due to the percent field total (This is complex to explain but easy to show in a example.

total sales = .25 (Cents) This total is being multiplied by .10 to figure out 10% of the total sales = .03 (This calculation is correct)

Then when I go to subtract .25 - .03 = .23 (Which is not correct, rounding is set to 0.01 on the field)

I have this report in 8.5 with all the patches and I have also download crystal report 11 with the same result, Any help would be appreciated

[Former Member]

Post Author: SKodidine

CA Forum: Formula

For Total Sales, try

round(0.25 * 0.10,2)

Then when you subtract it from 0.25 it should give you 0.22 instead of 0.23.