I have a KPI that works out the average of a % field based on filters selected.
The Expression is:
=Avg([Total Overpayments LEO %])
My problem is, I need to work our the above for the last 12 months on a rolling basis.
I have this Expression, and I thought it worked, however, it does not match if I select only 12 months of data for the expression above. The expression is:
rangeavg(above(Avg([Total Overpayments LEO %]),0,12))
Now, I know what the problem is, I just dont know how to rectify it.
The First expression is working out the average of all of the % in the [Total Overpayments LEO %]
The Second Expression is working out the average of the [Total Overpayments LEO %] grouped by month, so giving an average of average.
So what I need, is for the second expression to work out the average based on all of the % in the field without grouping them by month.
