0 Replies Latest reply: Aug 9, 2012 6:01 PM by olivierdom RSS

    Comparing monthly values to average - using Aggr() ?

      Dear all,

       

      I would like to create an expression comparing the value of an expression for a month to the average (or sum) of the same expression for all months.

       

      I think I should use an aggr function but cannot manage it.

       

      Maybe the Excel file will be more explicit (in the yellow column, the expression I'd like to create).

       

      I made various tries with aggr(sum(spacecrafts),NumMonth)/aggr(avg(inhabitants),NumMonth), Aggr(sum(spacecrafts),NumMonth,Planet)... but I allways get 1 as result.

       

      If someone could help me understand how to do that...

       

      Regards

       

      Olivier