https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-integer-to-decimal/m-p/624848#M217219 <P>Hello&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/250570">@isac_santana</a>&nbsp;<BR /><BR />If you want to convert an integer number to decimal, try dividing the number as shown below<BR /><BR /></P><P>| eval Amount = balance_amount/100</P><P>If this helps an upvote would be appreciated.</P><P>Thanks,</P><P>Manasa</P> Tue, 20 Dec 2022 13:00:57 GMT Manasa_401 2022-12-20T13:00:57Z https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-integer-to-decimal/m-p/624846#M217217 <P><SPAN>Good Morning,<BR />I'm having trouble converting a whole number to a decimal.&nbsp;</SPAN><BR /><BR /><BR /><STRONG>Example:</STRONG></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">| eval Amount = round(tonumber(balance_amount), 2) Result: 814118225.00</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P><BR /><BR />But I need the number to look like:&nbsp;&nbsp;<STRONG>8141182.25</STRONG></P> Tue, 20 Dec 2022 14:40:49 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-integer-to-decimal/m-p/624846#M217217 isac_santana 2022-12-20T14:40:49Z https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-integer-to-decimal/m-p/624848#M217219 <P>Hello&nbsp;<a href="https://community.splunk.com/t5/user/viewprofilepage/user-id/250570">@isac_santana</a>&nbsp;<BR /><BR />If you want to convert an integer number to decimal, try dividing the number as shown below<BR /><BR /></P><P>| eval Amount = balance_amount/100</P><P>If this helps an upvote would be appreciated.</P><P>Thanks,</P><P>Manasa</P> Tue, 20 Dec 2022 13:00:57 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-integer-to-decimal/m-p/624848#M217219 Manasa_401 2022-12-20T13:00:57Z