Home Dashboard Directory Help
Search

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


Status: 

Active


77
0
Sign in
to vote
Type: Suggestion
ID: 448127
Opened: 5/12/2009 3:27:07 AM
Access Restriction: Public
1
Workaround(s)
view

Description

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.
Details
Sign in to post a comment.
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.
Sign in to post a workaround.
Posted by Martin Cairns on 7/26/2013 at 7:47 AM
You can use Divide (<numerator>, <denominator> [,<alternateresult>]) function in SSAS 2012 SP1 onwards ;)