This is my current expression, I am wondering how can I use the IF statement to say that if the denominator is 0, then set the value to null. (Right now I get error since you can't divide by 0). If the denominator is not 0, do the regular calculation.
If the denominator is 0, then I want the value to be null or 0, sorry I didn't specify it before. Either way works for me. I used it in my cube, but got some syntax error. I guess I need to somehow convert it to mdx.