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.
http://docs.splunk.com/Documentation/Splunk/6.2.6/SearchReference/CommonEvalFunctions
ceil(X), ceiling(X)
This function rounds a number X up to the next highest integer.
This example returns n=2:
... | eval n=ceil(1.9)
Hi jclemons,
I believe you can use round fucntion.
round(fieldname,2) here 2 is for 2 decimal points.
In your case round(fieldname,0)
-Krishna Rajapantula
look at the ceiling function, it rounds up.
http://docs.splunk.com/Documentation/Splunk/6.2.6/SearchReference/CommonEvalFunctions
ceil(X), ceiling(X)
This function rounds a number X up to the next highest integer.
This example returns n=2:
... | eval n=ceil(1.9)