topic Re: Weighted Average Total not working correctly in QlikView

Weighted Average Total not working correctly

qlikofba — Tue, 26 Sep 2017 21:06:56 GMT

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

Re: Weighted Average Total not working correctly

swuehl — Tue, 26 Sep 2017 21:22:30 GMT

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.

Re: Weighted Average Total not working correctly

sunny_talwar — Tue, 26 Sep 2017 21:41:02 GMT

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

Re: Weighted Average Total not working correctly

vkish16161 — Wed, 27 Sep 2017 01:19:21 GMT

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])