Solved: Turn % into a Whole Number

e175429 · ‎04-13-2023

Hello All,

I am trying to show a NPS score. When I enter the inital calculations, it gives me a %. How do I turn this into a whole number to just say -27?

When I change "Percentage" to "Whole Number" I get:

Which confuses me even more

DOLEARY85 · ‎04-13-2023

Hi,

transforming a percentage to a number will always show 0 unless it's 100% then it will be 1. If you add some decimal places to the number you should see that 27% is 0.0027

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

View solution in original post

tamerj1 · ‎04-13-2023

Hi @e175429

Just muliply by 100 and change the data type to integer

DOLEARY85 · ‎04-13-2023

Hi,

transforming a percentage to a number will always show 0 unless it's 100% then it will be 1. If you add some decimal places to the number you should see that 27% is 0.0027

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍