Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Rounding

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.

Former Member
replied

Hi,

Try this,

totext({Formula;},"0.0000000")

Hope this hepls,

Vinay.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question