- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Calculating a sum of multiple locations
Hello,
I asked a question yesterday and have a little more information to provide!
So, my goal is to calculate the total reading/output of a specific city and compare it to what is required by law. I take the last 90 days of readings to calculate this.
Here's what I want: the average readings by specific equipment, and then the total of the averages (picture attached)
Right now, I have a measure that calculates the # of readings in the last 90 days, the sum of the readings, and it divides to find the total average.
Measure =
The measure above is essentially performing this...
It combines all the values and calculates a total average. Instead, I would want a measure that adds 250, 350, and 324 to give me a total "average" of 924.
Please let me know if I need to add any other info for help.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
The below formula should work for your requirment.
Follow me on LinkedIn.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Hi,
The below formula should work for your requirment.
Follow me on LinkedIn.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-01-2024 07:56 PM | |||
12-19-2024 10:34 AM | |||
10-04-2024 01:32 AM | |||
10-21-2024 06:57 AM | |||
11-23-2024 02:21 AM |
User | Count |
---|---|
134 | |
106 | |
88 | |
55 | |
46 |