How to convert numeric values to decimal numbers?

[iamsplunker]

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

[richgalloway · Accepted solution]

An example event or two would be helpful, but perhaps this will get you started.

| eval Availability = round(tonumber(rtrim(Availability, "%")) / 100, 4)

[spitchika]

Yes your answer perfectly works...
| makeresults
| eval value="98.32%"
| eval Availability = round(tonumber(rtrim(value, "%")) / 100, 4)

[richgalloway]

If your problem is resolved, then please click the "Accept as Solution" button to help future readers.