I'm struggling to find a solution for a calculated field that relies on another calculated field. Namely I made a calculated field that divides the sum of two fields which gives me an average number. I want to take that value and divide it by the average of another field. In the image below agg(Avg minutes watched) is sum(duration)/sum(starts) what I want is Avg Minutes watched / Avg Length but I can not come up with a formula that produces the results I want.
I attached a workbook
1.42/3 = 47%
1.42/4 = 36%37%40%33%35%
Thanks
6 answers
Hi Paul, the reason its 45.5 instead of 47.3 is because average length isn't exactly an integer, there are decimals. (1.42/3.13 = .45) If you want 47.3, then do [Avg Minutes Watched]/round(avg([length])). -Fred
