https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511189#M143183 <P>An example event or two would be helpful, but perhaps this will get you started.</P><P>&nbsp;</P><LI-CODE lang="markup">| eval Availability = round(tonumber(rtrim(Availability, "%")) / 100, 4)</LI-CODE><P>&nbsp;</P> Mon, 27 Jul 2020 17:20:36 GMT richgalloway 2020-07-27T17:20:36Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511184#M143180 <P>I have a field called Availability and the field values are like 98.32 % and I want them to be converted as decimal numbers like "0.9832" please help</P> Mon, 27 Jul 2020 16:56:16 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511184#M143180 iamsplunker 2020-07-27T16:56:16Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511189#M143183 <P>An example event or two would be helpful, but perhaps this will get you started.</P><P>&nbsp;</P><LI-CODE lang="markup">| eval Availability = round(tonumber(rtrim(Availability, "%")) / 100, 4)</LI-CODE><P>&nbsp;</P> Mon, 27 Jul 2020 17:20:36 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511189#M143183 richgalloway 2020-07-27T17:20:36Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511190#M143184 <P>Yes your answer perfectly works...<BR />| makeresults<BR />| eval value="98.32%"<BR />| eval Availability = round(tonumber(rtrim(value, "%")) / 100, 4)</P> Mon, 27 Jul 2020 17:28:04 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511190#M143184 spitchika 2020-07-27T17:28:04Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511191#M143185 <P>If your problem is resolved, then please click the "Accept as Solution" button to help future readers.</P> Mon, 27 Jul 2020 17:29:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-numeric-values-to-decimal-numbers/m-p/511191#M143185 richgalloway 2020-07-27T17:29:27Z