- 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 | |||
10-04-2024 01:32 AM | |||
11-12-2024 12:34 PM | |||
10-21-2024 06:57 AM | |||
03-26-2023 06:33 PM |
User | Count |
---|---|
141 | |
115 | |
83 | |
63 | |
48 |