I'm hoping you can help me calculate the average for a set of numbers in a pivot/straight table?
As you can see, my dimension is [Snapshot Date]
My formula for the variance is =Sum([Active Count]) - Above(Sum([Active Count]))
How can I get an average of these numbers into a text box?
Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))
View solution in original post
This worked. With your answer and a bit of help from a colleague we managed to come up with the right solution.