+ Start a Discussion

Rounding to the 1/2 decimal

I have a strange rounding issue and I'm not sure if saleforce has a formula for this kind of rounding.  It's probably best explained with an example.


.1,.2,.3 would round down to the whole number

.4,.5,.6 would round to .5

.7,.8,.9 would round up to the next value.


So 88.3 becomes 88

     88.4 becomes 88.5

     88.7 becomes 89


I can write my own code to do this, but I was hoping there was already something out there.