HI.

I'm trying to do a SUM of two CUBEVALUE's in a Cell and i am Getting a #VALUE result every time one of them returns a #VALUE. I've tried encapsulating the individual CUBEVALUE in a IFERROR(..,0) but that doesn't work. It is like excel is not recognizing the "0" value of the IFERROR(..,0). The cell is set as a number format as well.

Here is an example:

=
SUM(
IFERROR(CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Amount]",...filters),0)
,
IFERROR(CUBEVALUE("ThisWorkbookDataModel","[Measures].[Sum of Amount]",...diff filters),0)
)

.. and one returns #VALUE

Any ideas?

Thanks