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

    Percentage of 2 measures

    Sally Safa



      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?