https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224200#M188269 <P>Hi jclemons,</P> <P>I believe you can use round fucntion.</P> <P>round(fieldname,2) here 2 is for 2 decimal points.</P> <P>In your case round(fieldname,0)</P> <P>-Krishna Rajapantula</P> Tue, 15 Sep 2015 05:30:18 GMT krishnarajapant 2015-09-15T05:30:18Z https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224198#M188267 <P>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..)</P> Tue, 15 Sep 2015 05:07:14 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224198#M188267 jclemons7 2015-09-15T05:07:14Z https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224199#M188268 <P>look at the <STRONG>ceiling</STRONG> function, it rounds up.</P> <P><A href="http://docs.splunk.com/Documentation/Splunk/6.2.6/SearchReference/CommonEvalFunctions">http://docs.splunk.com/Documentation/Splunk/6.2.6/SearchReference/CommonEvalFunctions</A></P> <P>ceil(X), ceiling(X) <BR /> This function rounds a number X up to the next highest integer. <BR /> This example returns n=2:<BR /> ... | eval n=ceil(1.9)</P> Tue, 15 Sep 2015 05:29:57 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224199#M188268 yannK 2015-09-15T05:29:57Z https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224200#M188269 <P>Hi jclemons,</P> <P>I believe you can use round fucntion.</P> <P>round(fieldname,2) here 2 is for 2 decimal points.</P> <P>In your case round(fieldname,0)</P> <P>-Krishna Rajapantula</P> Tue, 15 Sep 2015 05:30:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-round-a-decimal-up-to-the-nearest-whole-number/m-p/224200#M188269 krishnarajapant 2015-09-15T05:30:18Z