17 Replies Latest reply: Mar 25, 2013 5:16 AM by Gaurav Tyagi RSS

    average of rows in a column

      Hi all.
      I have a table as this:
      1 dimension: Year
      3 expression: Employees, Cost, NewValue
      YearEmployeesCostNewValue
      20114130014400
      20125270018000
      20137680025200
      I want calculate the colum NewValue. It is given: avarege of all the value in the column cost multiplied by each value of the column Employees.
      14400 = (1300+2700+6800)/3 * 4
      18000 = (1300+2700+6800)/3 * 5
      25200 = (1300+2700+6800)/3 * 7

      any ideas?
      Thanks!