Display 6 digit number with decimal

[MGlass]

I am trying to create a dashboard that uses a search that has a 6 digit number but need the a decimal on the last 2 numbers. 

This is the result I get.

index=net Model=ERT-SCM EM_ID=Redacted
| stats count by Consumption

199486

I would like it shown like this.

1994.86 Kwh

I have tried this but only gives me the last 2 numbers with a decimal

| rex mode=sed field=Consumption "s/(\\d{4})/./g"

[richgalloway · Accepted solution]

Have you tried math? 🙂

index=net Model=ERT-SCM EM_ID=Redacted
| stats count by Consumption
| eval Consumption = exact(Consumption/100)

[MGlass]

Math is cool, I did try /100 but did not use exact. doh.

Thanks for the reply.