
Contributor II
2023-01-18
08:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
1,131 Views
1 Solution
Accepted Solutions

.png)
Former Employee
2023-01-18
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))
1,154 Views
2 Replies

.png)
Former Employee
2023-01-18
09:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try
Avg(Aggr(Sum([Active Count]) - Above(Sum([Active Count])),([Snapshot Date],(NUMERIC,ASCENDING))))
1,155 Views

Contributor II
2023-01-18
10:36 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
This worked. With your answer and a bit of help from a colleague we managed to come up with the right solution.
Thank you!
1,100 Views
