You are here

ROUNDing to nearest No.


i noticed you have floor and ceiling functions which round a
number either up or down,
but i need to round to the nearest whole number,
i tried ROUND(X,number of decimals) like excel but that doesnt work
do you have a function that does that?



No, though we should add it as it is a common requirement. In the mean time you can use the popular workaround, floor(x+0.5), to achieve the same result.

Or the less popular (floor(((10^n)*x)+0.5))/(10^n) to round to n decimal places. It's probably possible to include this as a function in your personal profile, so that it can be used as round(x,n) in the model, but I've forgotten how to do that.