MDX needs a special division-by-zero operator - by Christopher Webb

Status : 


Sign in
to vote
ID 448127 Comments
Status Active Workarounds
Type Suggestion Repros 2
Opened 5/12/2009 3:27:07 AM
Access Restriction Public


So much time and space is spent in MDX handling division by zero, why not have a special operator for it or handle it automatically? At the moment we always have to use something like IIF(d=0, null, n/d) which takes a lot of unnecessary space, and is something people new to MDX often fail to do.
Sign in to post a comment.
Posted by Microsoft on 3/1/2017 at 9:24 PM
Closing this item since it was implemented:
Posted by Christopher Webb on 3/20/2014 at 2:25 AM
Yes, go ahead. Thanks for implementing this!
Posted by Kyle Hale on 3/19/2014 at 10:44 AM
So since this has been addressed with the DIVIDE function, can we close this suggestion?
Posted by Jason Tom Thomas on 11/19/2010 at 3:46 PM
any updates?
Posted by Microsoft on 7/28/2009 at 4:46 PM
Thanks Chris for your suggestion.
We will take a look at it.
Edward Melomed.