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...