MDX:Handling division by zero errors

Written by Karan Gulati on 28 November 2011. Posted in MDX

MDX statement...

If you notice where Value of Internet Sales is Null for Base Year in our case CY 2006 the result is 1.#INF

In our case for Accessories and Clothing we are getting result as 1.#INF because of simple reasons 1/0 is 1.#INF

1.#INF - is nothing but formatted value of infinity