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?