Skip to Content
1
Former Member
Feb 19, 2011 at 12:20 AM

Max of one column in another column

1232 Views

HI all

I have a scenario in the WebI report where I need to get the Maximum value from one column and use that maximum value in calculation of another column for each row in that column.

for ex:

column A

1

2

3

4

5

Max of column A [MAX]= 5

Column B

1/ [MAX]

2/[MAX]

3/[MAX]

4/[MAX]

5/[MAX]

Column B calculation is some thing like described above.

but my issue is, in WebI values are caluclated row wise and while generating values for the first row in column B, it picks the value 1 but the MAX value is not yet caluclated and if I use Max variable it is caluculating as 1/1 for first row and 2/2 and 3/3. Instead of 1/5, 2/5, 3/5.

Any idea please share it.

Thanks

Edited by: saathiyaa on Feb 19, 2011 1:23 AM