5 Replies Latest reply on Sep 26, 2013 5:49 AM by Antonio Willybiro

    Percentage calculation

    Antonio Willybiro

      hi -

       

      I have a dimension called 'account' with multiple values:

       

      • leavers
      • average headcount
      • ratio leavers to average headcount

       

      I have this data by company:

      • abc
      • edf
      • etc...

       

      I am trying to show the ratio leavers to average headcount on a chart and use the 'country' filter to see the % info by country.

       

      how should I best do this?

      sum ([ratio leavers]): doesn't work

      avg([ratio leavers]}: doesn't give an accurate picture

       

      is it possible to do a calculated field that would be based on two values of the same dimension i.e. using leavers and 'average HC' whole numbers

       

      I need something like ([value] for dimension of account = leavers) / ([value] for dimension of account = average headcount)

       

       

      Thanks

      Antonio