Skip to main content
Announcements
MAINTENANCE ALERT: Dec. 12th starting 9 AM CET. Community will be read-only. GET DETAILS
cancel
Showing results for
Search instead for
Did you mean:
Contributor II

## How to Calculate Average of Numbers?

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

Labels (2)

• ### Scripting

1 Solution

Accepted Solutions
Former Employee

Try

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

2 Replies
Former Employee

Try

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

Contributor II
Author

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

Thank you!

Community Browser