Forum Discussion

Ancar's avatar
Ancar
Frequent Visitor
9 years ago
Solved

Percent values comes with wrong decimals

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

 

 

Need Help
  • JoHo_BI's avatar
    JoHo_BI
    9 years ago

    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.

4 Replies

  • JoHo_BI's avatar
    JoHo_BI
    Responsive Resident
    9 years ago

    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's avatar
      Ancar
      Frequent Visitor
      9 years ago

      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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi Ancar,

     

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

     

    Regards

    • Ancar's avatar
      Ancar
      Frequent Visitor
      9 years ago

      Hi there,

      Yes, it worked perfect! Thanks!

      //Andreas