QlikView App Dev

[R0b]

Hi all,

I'm hoping you can help me calculate the average for a set of numbers in a pivot/straight table?

Snapshot Date	Variance
31/07/2022	151
31/08/2022	188
30/09/2022	116
31/10/2022	115
30/11/2022	-51
31/12/2022	28

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? 

Thanks,

Rob

[hic · Accepted solution]

Try

Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))

[R0b]

This worked. With your answer and a bit of help from a colleague we managed to come up with the right solution. 

Thank you!