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