Skip to main content
Solved

How do I format metrics to be whole numbers (remove decimals/round up)?

  • 25 June 2024
  • 1 reply
  • 71 views

I have a metric that has decimals and want to round it to a whole number. Couldn’t find any formula or setting to do so. Any tips would be appreciated

1 reply

Userlevel 5
Badge +9
Hi Oliver,

Hope you are well!

Unfortunately, Amplitude does not currently support rounding up or rounding down of decimal numbers directly in the platform. This has been a topic of discussion. I am assuming you are referring to chart results returning decimal values rather than a specific property containing the decimal value. If this is not the case please let me know.

However, you can export the data and perform the rounding operation in a tool like Excel or Google Sheets. I understand this might not be the ideal solution, but it's a workaround until we have this feature in Amplitude.
I hope this helps! If you have any other questions, feel free to ask.

For more information on Amplitude's features and how to use them, you can check out our video tutorials.

Best,
Eddie


P.S. Checkout upcoming events and user meetups on our events page.

Reply