topic Round to nearest 0.5 in Discussions

Round to nearest 0.5

pcannonsamsung — Mon, 24 Sep 2018 17:54:26 GMT

Hi,

I'm wondering if there is a way to use a formula to round numbers to the nearest 0.5 .

Thanks

Mark_Bailey — Mon, 24 Sep 2018 18:33:56 GMT

You can use this for a column formula:

Round( :Data * 2 ) / 2

Or you could make your own function in a script:

nearest half = Function( { x }, Round( x * 2 ) / 2 );

gzmorgan0 — Mon, 24 Sep 2018 18:40:50 GMT

x = [122.34, 10.2, 33.6, 45.75];

show( round( x/0.5,0 )*0.5 );

/*:
Round(x / 0.5, 0) * 0.5 = [122.5, 10, 33.5, 46];

oops, Mark beat me to it.