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.
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