5 Replies Latest reply on May 1, 2015 2:37 PM by Paul Edwards

    Caclulated field based on calculated field

    Paul Edwards

      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

      New field

      1.42/3 = 47%

      1.42/4 = 36%
      37%
      40%
      33%
      35%

       

      Thanks