https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72106#M18022 <P>Hi, I have the following</P> <PRE><CODE>| chart eval(sum(Failed)/sum(TotalEvents)*100) AS PercentFailed </CODE></PRE> <P>I would like to round the value that it produces to 2 decimal places. I have been unsuccessful trying to add in the round command. Anyone have any suggestions on how to do this?</P> Mon, 18 Oct 2010 22:53:53 GMT cramasta 2010-10-18T22:53:53Z https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72106#M18022 <P>Hi, I have the following</P> <PRE><CODE>| chart eval(sum(Failed)/sum(TotalEvents)*100) AS PercentFailed </CODE></PRE> <P>I would like to round the value that it produces to 2 decimal places. I have been unsuccessful trying to add in the round command. Anyone have any suggestions on how to do this?</P> Mon, 18 Oct 2010 22:53:53 GMT https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72106#M18022 cramasta 2010-10-18T22:53:53Z https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72107#M18023 <P>You can use round as follows:</P> <PRE><CODE>| chart eval(round((sum(Failed)/sum(TotalEvents)*100),2)) AS PercentFailed </CODE></PRE> Tue, 19 Oct 2010 00:06:00 GMT https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72107#M18023 ftk 2010-10-19T00:06:00Z https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72108#M18024 <P>thank you so much !</P> Tue, 19 Oct 2010 02:07:34 GMT https://community.splunk.com/t5/Splunk-Search/Rounding-Decimal-Places/m-p/72108#M18024 cramasta 2010-10-19T02:07:34Z