Aggregation of NULL Values

[peterfopma]

Just a very short question:
How is the aggregation of NULL-Values treated. According to my MDX-Reference (MDX Solutions, George Spofford) a NULL-Value should be treated like Zero in a calculation.
My tests with mondrian indicate that the result of a calculation is NULL, whenever a NULL Value is involved...
Thanks for your answer...
Peter Fopma

[peterfopma]

Again I will continue my own thread - I think this could be interesing for others, too...
Mondrian evaluates a calculation to NULL if at least one argument is NULL. This could be the cause of unexpected results since there are MDX references which propose that NULL is to be treated as zero in calculations except in the case when all arguments are NULL - then the result is NULL.
But there is still one question open:
Is this going to be changed in future releases?
Peter Fopma