Turn % into a Whole Number

[e175429]

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

[tamerj1]

Hi @e175429 

Just muliply by 100 and change the data type to integer 

[DOLEARY85 · Accepted solution]

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 👍