I am creating a cube in Microsoft SQL Server 2000. The Query of a calculated member returns text such as "1.#INF or 1.#J" instead of the number. Cause: The formula in the calculated member attempted to divide by zero. Solution: Change the formula to check for possible division by zero errors before they occur.


***How do i write the statement using the Caculated Member Builder within the Cube Editor to do this?***

Please Help,