Calculating totals with members with missing values

[leahmarie]

Has anyone had any success with adding totals when there are missing values or divide by zero values?  I have tried using the coalesce function but I haven't had any luck.  I also tried a case statement with when is missing "0" but no luck with that either.  Any insight?

It is an OLAP cube. 

[RobsWalker68]

Hi,

I would usually use an if statement so something like:

if ([TotalA] is null) then (0) else ([TotalA])
+
if ([TotalB] is null) then (0) else ([TotalB])


Rgds

Rob