on 04-06-2009 9:55 PM
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.
Hi Right click on the formula > format fields > Numbers > Customize > Change the rounding to 0.00000
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.