I have a Calculated Member that displays values of 999.0 when the calculation cannot be computed based on certain criteria. I would like to be able to format the numeric field so that is displays a character such as "X" when the value of the Calculated Member is 999.0. Does anyone know how to do this?
If this is in Analysis Services 2005, you should be able to use the IIF() MDX function to return either the value or "x".|||Thanks. That worked!
I have a Calculated Member that displays values of 999.0 when the calculation cannot be computed based on certain criteria. I would like to be able to format the numeric field so that is displays a character such as "X" when the value of the Calculated Member is 999.0. Does anyone know how to do this?
If this is in Analysis Services 2005, you should be able to use the IIF() MDX function to return either the value or "x".|||Thanks. That worked!
