Showing results for 
Search instead for 
Did you mean: 

Wrong rounding of decimal rollup field

Author Name: JIRI CABAL

If you set a decimal rollup field with precision of 0 to sum up decimal fields with precision of 1 (or another), the rounding is done before summing up and that is a big problem.

It does SUM(ROUND(x)) instead of ROUND(SUM(x)).

We have plenty of scenarios, where we don’t need such precision in the top level (rollup field), but we can’t be losing it in the bottom level.

Imagine rolling up sum for 9 records with value 0.5. The sum is 4.5. If precision of 0 is needed, than it should be 5 – that is ok. But the rollup field gives me 9 (9x1) – and that is really not ok.

Status: New
Regular Visitor
Status changed to: New