6 Replies Latest reply: Aug 6, 2015 10:35 AM by Sjoerd Stilma RSS

    Calculating average of two percentages.

      Hi there,

       

      Is there an easy way to determine the average of two percentage values? In the example below I want to determine the average of pie chart 1 and 2. Ive set the pie chart on option 'relative' so that it shows the percentages of the actual values. (the pie charts below it)

       

      But now I want to determine the average of those percentages.  (% + %  ) /2 = average%

       

      But this cannot be done because the actual values qlikview calculates with are the real values in the graphs below it. Therefor giving faulty percentages. How can I do this>?

      why.png