Missing Values

jaimeoconor — Sat, 16 Nov 2024 20:22:36 GMT

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!

Re: Missing Values

agni_gold — Sat, 27 Jul 2019 20:56:20 GMT

see attached