
Re: Problem with rounding
Sunny Talwar May 14, 2015 9:36 AM (in response to Matt Maino)That is weird. Can you share a application where it is doing this? Only thing I can think of which might be throwing this off could be that the calculation has numbers and text in it. So when its number it goes in the right bucket, but when its text it is not able to round and is being pushed to 'no value'
Best,
Sunny

Re: Problem with rounding
Matt Maino May 14, 2015 9:50 AM (in response to Sunny Talwar )The values that are wrongly being placed in the 'no value' bucket are on the boundaries of each bucket  so some of the .6, .65, .66, .70, .71, .75, .76 and .80 vaues. This makes me think that the round() function is not actually changing the value, just displaying it differently

Re: Problem with rounding
Sunny Talwar May 14, 2015 9:53 AM (in response to Matt Maino)If that is the case, then may be you can use this instead:
=if(round(calculation, 0.01) < 0.6, '< 60%',
if(round(calculation, 0.01) >= 0.6 and round(calculation, 0.01) < 0.66, '6065%',
if(round(calculation, 0.01) >= 0.66 and round(calculation, 0.01) < 0.71, '6670%',
if(round(calculation, 0.01) >= 0.71 and round(calculation, 0.01) < 0.76, '7175%',
if(round(calculation, 0.01) >= 0.76 and round(calculation, 0.01) < 0.81, '7680%',
if(round(calculation, 0.01) >= 0.81, '> 80%', 'no value'))))))

Re: Problem with rounding
Sunny Talwar May 14, 2015 9:55 AM (in response to Sunny Talwar )Or for more accurate results:
=if(round(calculation, 0.01) < 0.6, '< 60%',
if(round(calculation, 0.01) >= 0.6 and round(calculation, 0.01) < 0.655, '6065%',
if(round(calculation, 0.01) >= 0.655 and round(calculation, 0.01) < 0.705, '6670%',
if(round(calculation, 0.01) >= 0.705 and round(calculation, 0.01) < 0.755, '7175%',
if(round(calculation, 0.01) >= 0.755 and round(calculation, 0.01) < 0.805, '7680%',
if(round(calculation, 0.01) >= 0.805, '> 80%', 'no value'))))))




Re: Problem with rounding
Michael Solomovich May 14, 2015 9:53 AM (in response to Matt Maino)Try:
=if(round(calculation, 0.01) < 0.6, '< 60%',
if(round(calculation, 0.01) >= 0.6 and round(calculation, 0.01) < 0.65, '6065%',
if(round(calculation, 0.01) >= 0.65 and round(calculation, 0.01) < 0.70, '6670%',
if(round(calculation, 0.01) >= 0.70 and round(calculation, 0.01) < 0.75, '7175%',
if(round(calculation, 0.01) >= 0.75 and round(calculation, 0.01) < 0.80, '7680%',
if(round(calculation, 0.01) >= 0.8, '> 80%', 'no value'))))))
Besides, I don't see need for rounding at all here (?)
Edit: fixed boundaries