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

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

• ###### 1. Re: how to calculate the ratio btw the current cell value to the max value of the entire column of cells

Hi Joe,

I believe what you are looking would require a Table Calculation to get this done. I copied the data that you provided and got to the attached view using the following Table Calculation:

SUM([temperature]) / TOTAL(SUM([temperature]))

Is this what you were looking for?

Cheers

Siraj

• ###### 2. Re: how to calculate the ratio btw the current cell value to the max value of the entire column of cells

Hi, Siraj, what I'm asking is how to create another column "T_max" of which the value is the max value of the first column "T":

T     T_max

1     10

2     10

5     10

7     10

10    10

• ###### 3. Re: how to calculate the ratio btw the current cell value to the max value of the entire column of cells

Hi Joe,

Using the workbook Siraj created, create a calculated field similar to the following:

window_max(max(temperature))

Then, depending how the view is set up, it may be necessary to edit how the calculation is computed (to do this, right click and select Compute Using...)

Hope this helps!

-Tracy