Adding Null Cube Dimensions

[davephall]

Hi there, I've got a report based on a powercube, which has a section with two dimensions at the same nesting level that I want to add together. I've used the formula [Capital Replacements] + [Capital Adaptations] to add the two together, which works fine.

My problems start when one of these returns a null due to the slicer applied to the report. This then returns a null result. Is there any way of changing nulls to zeros in this situation so that the calculation returns the other value?

Thanks In advance, Dave.

[pratyush]

Hi there, I've got a report based on a powercube, which has a section with two dimensions at the same nesting level that I want to add together. I've used the formula [Capital Replacements] + [Capital Adaptations] to add the two together, which works fine.

My problems start when one of these returns a null due to the slicer applied to the report. This then returns a null result. Is there any way of changing nulls to zeros in this situation so that the calculation returns the other value?

Thanks In advance, Dave.

Hi

Before doing your " [Capital Replacements] + [Capital Adaptations] "  have a if loop for checking a NULL value .. if you get a NULL value then assign it as 0 ...

Cheers ...

[davephall]

Now you say it, it's obvious! For some reason I didn't think that'd work in a powercube. It worked perfectly, thanks for your help!

Dave.