
1. Re: Looking for a formula guru  SUM & LOD & MAX
Jim Dehner Mar 16, 2018 9:18 AM (in response to Kerry Page)Hi Kerry
see the attached  there are 2 options  one with and LOD the other without
You don't really an lod but you might want it for use elsewhere
the one thing I did do was pivot your data to look like this
Pivot Data from Columns to Rows
then it is just a matter of using grand total on the table that results
You can use and LOD also
it does let you just see the totals
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

Facilities_v10.2.twbx 52.9 KB


2. Re: Looking for a formula guru  SUM & LOD & MAX
Simon Runc Mar 16, 2018 9:19 AM (in response to Kerry Page)hi Kerry,
I've created this formula (indeed an LoD!)
[MAX Calc per Facility]
{FIXED [Facility Number]:
SUM({FIXED [Facility Number], [Meter Number]: [MAX CALC]})
}
Let me know if this is what you were after? and if so, let me know if this doesn't make sense!

Facilities  SR 10.3.twbx 28.5 KB


3. Re: Looking for a formula guru  SUM & LOD & MAX
Kerry Page Mar 19, 2018 8:32 AM (in response to Jim Dehner)Thanks so much, Jim. I learned something new with the pivoting  I pivoted my fields and this view helped tremendously!  Kerry

4. Re: Looking for a formula guru  SUM & LOD & MAX
Kerry Page Mar 19, 2018 8:33 AM (in response to Simon Runc)1 of 1 people found this helpfulHi Simon, thanks for the reply. This formula appears to have summed up all of the meters @ each facility. I pivoted the data beforehand using Jim's suggestion.