https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152758#M185583 <P>I am using the below query to form a table, but the percent values have up to 6 decimal places.<BR /> Can you please let me know how to limit them to 2 decimal places?</P> <P>Query:<BR /> index=jms_logs osb_Service="CRMCaseService.Services.CRMCaseService" | eventstats count by Reason | top Reason</P> <P>Results:<BR /> Reason count percent<BR /> Case(s) updated successfully 144 96.000000<BR /> Could not update case since Case not found in salesforce 5 3.333333<BR /> Case Found but the contact information does not match 1 0.666667 </P> <P>Thanks.</P> Mon, 28 Sep 2020 17:08:28 GMT edookati 2020-09-28T17:08:28Z https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152758#M185583 <P>I am using the below query to form a table, but the percent values have up to 6 decimal places.<BR /> Can you please let me know how to limit them to 2 decimal places?</P> <P>Query:<BR /> index=jms_logs osb_Service="CRMCaseService.Services.CRMCaseService" | eventstats count by Reason | top Reason</P> <P>Results:<BR /> Reason count percent<BR /> Case(s) updated successfully 144 96.000000<BR /> Could not update case since Case not found in salesforce 5 3.333333<BR /> Case Found but the contact information does not match 1 0.666667 </P> <P>Thanks.</P> Mon, 28 Sep 2020 17:08:28 GMT https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152758#M185583 edookati 2020-09-28T17:08:28Z https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152759#M185584 <P>Try this</P> <PRE><CODE>index=jms_logs osb_Service="CRMCaseService.Services.CRMCaseService" | eventstats count by Reason | top Reason | eval percent=round(percent,2) </CODE></PRE> Tue, 22 Jul 2014 17:18:56 GMT https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152759#M185584 strive 2014-07-22T17:18:56Z https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152760#M185585 <P>perfect. It worked.</P> Tue, 22 Jul 2014 17:20:19 GMT https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152760#M185585 edookati 2014-07-22T17:20:19Z https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152761#M185586 <P>Isn't the <CODE>eventstats</CODE> obsolete in that search?</P> Tue, 22 Jul 2014 17:31:45 GMT https://community.splunk.com/t5/Splunk-Search/how-to-limit-percent-results-to-2-decimal-places/m-p/152761#M185586 martin_mueller 2014-07-22T17:31:45Z