Hello.. is there anyway to round a decimal UP to the nearest whole number? (e.g.. I would like 0.1 to be 1, 8.00001 to be 9, 8.56 to be 9 etc..)
look at the ceiling function, it rounds up.
This function rounds a number X up to the next highest integer.
This example returns n=2:
... | eval n=ceil(1.9)
View solution in original post
I believe you can use round fucntion.
round(fieldname,2) here 2 is for 2 decimal points.
In your case round(fieldname,0)