Hi,
I have, for example, the following data:
Fund Asset 1 Asset 2 Asset 3
Fund 1 20% 70% 10%
Fund 2 5% 70% 25%
Fund 3 60% 40%
Fund 4 100%
I'm creating a table (a heat map in fact) showing every Asset % and the result of that Asset % - Fund 1 Asset %. The result should be the following:
Fund Asset 1 Asset 2 Asset 3
Fund 1 0% 0% 0%
Fund 2 -15% 0% 15%
Fund 3 40% -70% 30%
Fund 4 80% -70% -10%
But, as there are missing values, those cells containing missing values return nothing when I do:
RangeSum( Sum([%]), -Sum(TOTAL {<Fund = {'Fund 1'}>}[%]) )
Any ideas?
Many thanks in advance!
