Missing Values

[jaimeoconor]

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!

[agni_gold]

see attached