This content has been marked as final. Show 2 replies
I am trying to build a Xmr Chart with the data below. There is an Month/Year filter and I always calculate the Average and the Moving Range Average with the selected data only*.
But I am having a hard time to calculate de Moving Range Average, I always get an erron on the expression.
|Year/Month||Sales||Average *||Moving Range||Moving Range Avg|
The Average I used the expression: sum(total(Sales))/GetSelectedCount(Year/Month)
For the Moving Range: fabs(sum(Sales)-below(sum(Sales)))
And for the Moving Range Avg I tried unsucessfully to use: sum(total(fabs(sum(Sales)-below(sum(Sales)))/GetSelectedCount(Year/Month)
Can anyone help me please?
Thank you very much.