3 Replies Latest reply on Jul 18, 2018 5:42 AM by Naveen B

    Percentage of 2 measures

    Sally Safa

      Hello,

       

      I have 2 measures and 2 dimensions:

       

      Dimension: Country/location and Rate

      measures: Limit and Utilized USD

       

      I am trying to calculate the percentage of utilized amount from the limit amount per country.

       

      Foe example if Limit for country A with rate 1 is 7,520 and Utilized USD is 5000 then the utilized percentage is around 66% (Utilized USD*100)/Limit.

       

      I created a calculated field and added the formula but the results do not make sense. I attached a sample workbook in case anyone can help.

       

      What am I doing wrong in the calculation of % field?

       

      Thanks!