how can I test for NaN (not a number)?

#1

Can someone give me an example of testing for NaN?

I want to do something like this:

member [measures].[mv] as 'iif([measures].[measure
value]=NaN,0,[measures].[measure value])'

Thanks,
Bill

#2

Try VBA!IsNumeric([measures].[measure value])

HTH

Milind

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

how can I test for NaN (not a number)?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

how can I test for NaN (not a number)? - 01-11-2006 , 01:36 PM

Re: how can I test for NaN (not a number)? - 01-12-2006 , 08:09 AM