Good morning all I am needing some clarification on the following if possible. I have automation using stored values when rounding up to a whole number how many decimal places does automation look back eg 0.1or 0.01or 0.001 and so on.
Many thanks Rollox
STORED VALUES - ROUNDING
Thanks Dallas, so if I have store value set to 2 decimal places and want to round to nearest whole number up or down will it use first decimal place or second place to round. Many thanks Rollox
The way I was taught it would be from second decimal place but looking online it seems to be from one decimal place this is where my confusion is coming from
The way I was taught it would be from second decimal place but looking online it seems to be from one decimal place this is where my confusion is coming from
You have the option of rounding up or down to a round number or rounding to the nearestRollox wrote: ↑Tue Oct 17, 2023 1:38 pmThanks Dallas, so if I have store value set to 2 decimal places and want to round to nearest whole number up or down will it use first decimal place or second place to round. Many thanks Rollox
The way I was taught it would be from second decimal place but looking online it seems to be from one decimal place this is where my confusion is coming from![]()
In which case 1.51 will be rounded to 2.0 and 1.49 rounded to 1.0
Honestly not sure which way 1.50 rounds too - you'd have to store it as an entered amount and see which way it goes

-
- Posts: 1676
- Joined: Fri Nov 20, 2015 9:38 am
There used to be a convention to round these cases to the nearest "even" number...
(or was it odd number!)
edit - or in the case of businesses, always round in your favour.