0 Replies Latest reply: Sep 24, 2013 5:55 AM by Thirunavukkarasu M RSS

    Calculating the 2-Week Moving Average of % Bi-weekly ?

      Friends,

       

      How to calculate the 2-Week Moving Average of % Bi-weekly ?


      I have the formula to calculate this. But which is showing wrong  values.

       

      (If(RowNo() > 0, Ceil(Aggr(Rangesum(Above(Sum(A), 0, Rowno() )+ Sum(A)), isoWeek) / Aggr(Rangesum(Above(Sum(B), 0, Rowno() ) + Sum(B)), isoWeek)*100,0.01))))

       

      Could you help me to solve this?

       

      Regards

      Thiru