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
      110%
      220%
      330%
      440%
      10100%

       

       

      help is appreciated!

       

      - Ji