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.

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