Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies