3 Replies Latest reply on Sep 6, 2012 3:31 PM by Tracy Rodgers

    how to calculate the ratio btw the current cell value to the max value of the entire column of cells

    Joe Smith

      suppose I have one column A of data, each row is the temperature measured at a specific time


      for each cell I want to create a new column B which record the ratio btw the cell value in column A to the max value among column A.


      May I ask how to do that?


      I try to create a new calculated field as:

      [temperature] / MAX( [temperature] )


      But it doesn't work, saying "can't mix aggregated and non-aggregated arguments"


      temperature% of Max



      help is appreciated!


      - Ji