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   ...
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.

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