Hi All
I want calculate ration between individual cell value and average of those sum.
Data
Student Marks Fraction
S1 70 0.875
S2 80 1.0
S3 90 1.125
----------------------------------
Avg Marks= 80
I want To calculate the fraction?
Thanks in Advance
-
Sai
3 answers
Hi Sai,
create Calculation as
sum([Amount])/window_Avg(sum([Amount]))
change the number format and select percentage and drag this into text.
Thanks
sankar