I sometimes get -1.#IND and -1.#J values in my cells, what is this

and how can I replace it with my own values for example if the value

is -1.#IND then display "unknown IND" if the value is -1.#J then display

"unknow j"





Note that I now that when we divide zero by zero we get

-1.#IND (right?) , but when do we get -1.#J arises.





any links , pointers?



Thanks



Asim Naveed


--
Posted via http://dbforums.com

Hi,

The following table shows query return values from using different
FORMAT_STRING's in an expression involving 'division by zero' (tested on
Intel platforms):

+===========================+===================== +

In general, avoid division by zero whenever possible. Inside a calculated
member, use explicit checking before dividing. For example, instead of the
expression 'Sales / Units', use the function 'iif' such as 'iif ( Units =
0, 0, Sales / Units )'.

NOTE: The explicit checking may not always work. It will work for integer
values, but may fail for real values.

HTH,
Bas


"This posting is provided "AS IS" with no warranties, and confers no
rights."

Thanks for your response , but i cannot check wheather denominator is

zero or not, because i am using COORELATION MDX function.

the correlation functions is returning to me the 1.#IND value

and 1.#J value. coorelation functions internally uses a formula

which includes denominoator, that denominator is out of my control,

so i cannot use iif.



Thanks

Asim Naveed


--
Posted via http://dbforums.com