Percent values comes with wrong decimals

[Ancar]

Hi all,

I am facing a problem where the database I am importing contains a percentage value (average unsubscription rate for instance) and it is, let's say 1,5%

I am getting the value as 1,5

Converting that through "modeling" --> "percentage formatting" makes it: 150,0% (since 1,5 is 150 in percent). 

I would like either for it to understand that it already is 1,5% and thus just add a %-sign at the end, OR I would like to move the decimal to: 0,015 and then add the percentage formatting. 

The outcome should be that the 1,5 i have today is the actual percentage (that just lost it's %-sign) 

Thanks a lot

Andreas

[v-ljerr-msft]

Hi @Ancar,

Have you tried the solution provided by JoHo_BI above? It should work in your scenario.

Regards

[Ancar]

Hi there,

Yes, it worked perfect! Thanks!

//Andreas

[JoHo_BI · Accepted solution]

Hi Andreas,

Add another calculated column such as:

AUR = [Average Unsubscription Rate]/100

Put this into a percentage and you'll get the required result.

[Ancar]

Hi JoHo_BI,

Thank you for the reply and the solution - it worked perfect! Exactly what I needed! Thanks a lot for your help!

Kind regards,

Andreas