Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The formula below calculates the weighted average of the interest rate. Each row/line item matches up perfectly but my total row does not. Is there a way to calculate a total of the weighted average?
sum({$<Month={'7'},Year={'2017'}>}([CD Balance]*[Interest Rate]))/Sum({$<Month={'7'},Year={'2017'}>}[CD Balance])
Thanks
Can you tell us more about the context?
It's hard to tell what's wrong without knowing what you get using which input and what you expect to see instead.
Are you looking to sum the individual rows for your total? May be try this
Sum(Aggr(Sum({$<Month={'7'},Year={'2017'}>}([CD Balance]*[Interest Rate]))/Sum({$<Month={'7'},Year={'2017'}>}[CD Balance]), Dimension/s))
Replace the Dimension/s part with the list of dimensions from your chart
Try like this maybe.... more context needed.....
sum(TOTAL<Dimension> { $<Month={'7'},Year={'2017'}>}([CD Balance]*[Interest Rate]))/Sum({$<Month={'7'},Year={'2017'}>}[CD Balance])