2 Replies Latest reply: Apr 18, 2015 9:31 AM by Massimo Grossi RSS

    Aggregation - Percentages Average

      Hi All,

      I am in trouble and struggling with designing an expression which seems to me pretty simple, but in fact, I was able to write it down as expected.

      Let me show you the scenario:

       

      pivot.png

       

      So, I have that for each date, I calculate the avg value and calculate a percentage of "improvement" of the value, following this formula: input-output/input*100.

       

      This works fine when I have the Date Dimension (as in the picture). But I want to remove it and calculate an average of the formula (input-output/input*100). I do not want avg(input)-avg(output)/avg(input)*100, but the percentage average.

       

      May you please help me to reach this goal? How can this be done?

       

      Thanks in advance for your help!!