
1. Re: Total of percentages calculation query
Jim Dehner Aug 29, 2018 4:49 AM (in response to Graeme Elliott)2 of 2 people found this helpfulHi
see the attached
the formula below
will return this in your text chart
this happens because table calculations happen after totals in the order of operation
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.

2. Re: Total of percentages calculation query
Graeme Elliott Aug 29, 2018 5:02 AM (in response to Jim Dehner)Thank you so much! Order of Operations and LOD Calcs are two things I am now going to look into this week. Thanks for the help, most appreciated.

3. Re: Total of percentages calculation query
Jim Dehner Aug 29, 2018 5:14 AM (in response to Graeme Elliott)Thanks
The Order of Operation affects many calculations  when you look into the topic of LOD's also look at Context filters
and when you look at table calculations look at lookup(attr(dim),0) and its affect on the order of operation  it will help you out of some (not all) issues in calculating totals
Glad to help out
Jim