cancel
Showing results for 
Search instead for 
Did you mean: 

Rounding

Former Member
0 Kudos

I have report totals that are off because the precision of numbers the totals are based on are higher than that displayed on the report. Is there a way around this without displaying numbers with 5 or 6 numbers to the right of the decimal on the report?

The following code is displayed as a detail line


if {fld1} > 0 then
({fld2}/{fld1})*100
else 0

The following code is acting as a total to the detail line above


if Sum ({fld1}, {@GrpSort}, "daily") > 0 then 
(Sum ({fld2}, {@GrpSort}, "daily")/Sum ({fld1}, {@GrpSort}, "daily")) * 100
else 0

But, like I mentioned, the values displayed on the report don't work out.

Here's what I get:


193.34
259.12
0.00
243.84

Total: 236.18

The total should be 232.1 if you do the math on the numbers displayed.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Right click on the formula > format fields > Numbers > Customize > Change the rounding to 0.00000

Former Member
0 Kudos

Theres no 0.00000 option. I tried setting this to 0.000001 but when I come back in to check it, it reverts back to 0.01

Former Member
0 Kudos

Hi,

Try this,

totext({Formula;},"0.0000000")

Hope this hepls,

Vinay.

Former Member
0 Kudos

I ended up changing the displayed value for to be -1123.0000 and this made the report average correctly.

Answers (0)