Bit of a conundrum here, I am measuring potential savings for our sites and have worked out some rather complex calcs for them. Our sites are banded by Population Equivalent (PE).
The trouble I'm having is each site has a saving based on it's PE but when I work out the total banded the sum savings aren't matching (figure below bottom figure is right). I suspect this is because it is taking either an average of the PE or some other sum of sites that aren't affecting it.
Is there a way, most likely using the aggregate function by Source Name, that I can make the top total match the bottom?
I'd like to avoid dipping into the calcs if possible as they are very long and convoluted and due to confidentiality I can't post them on here.
This strikes me as one possible source of issues - if there is the same value attached to more than one category in your second table, you'll end up using it twice there, but only once in your top table.
I'd consider splitting out your expression into component parts to trace which element is not adding up.