IsValid function for AS2005? -
11-08-2006
, 12:21 PM
Essbase has an IsValid function which can be used for detecting -1.#IND
results. How can I detect -1.#IND with an IIF and convert it to a null
in Analysis Services 2005 (like with the IsValid function)?
I'm doing STDEV calculations and the -1.#IND results are getting
returned for all dates for which there is 1 or less non-null values,
and I'd prefer to simply do a blanket conversion of these results to
nulls. |