Splunk Search

How to format as percent with 2 decimal places and no rounding?


How do you convert .34999832 to 34.99% or .399345 to 39.99%

I need to see the .99 and not have it round up


Labels (1)
0 Karma

Esteemed Legend

You have many options:
1: round() <-you dislike this
2: replace()
3: ciel()
4: floor()
5: substr()
6: rex

0 Karma


We use the below to show free disk space on a drive.
eval MBs=round(b/1024/1024,2)
the 2 at the end will tell it how many decimals to carry it out.

0 Karma


Hi @mbtsoltis,

you can use eval and round, please try something like this:

| eval your_field=round(your_field*100,2)

if Splunk doesn't recognize a number, you can use the tonumber function:

| eval your_field=to_number(round(your_field*100,2))



Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...