MDX Calculated measure help in DeepSee

Question

Question

Benjamin Bryans · Nov 21, 2016

#InterSystems IRIS BI (DeepSee) #Analyzer #MDX

I currently have an MDX query/calculated measure as per the below:

[DaysOnListRange].[H1].[DaysOnListRange].&[Days 91 - 180]+ [DaysOnListRange].[H1].[DaysOnListRange].&[Days 181 - 365]+
[DaysOnListRange].[H1].[DaysOnListRange].&[Days 365+]

however it currently doesn't sum when there is a blank in the data.
How can I amend this query to include empty cells/only sum cells with data?

I've tried using nonempty but it doesn't appear to work in this context

Discussion (2)0

Log in or sign up to continue

Peter Steiwer · Nov 21, 2016

Hi Benjamin,

In DeepSee, Null data is handled differently than 0. This being the case, you can use the ISNULL function (Documentation). Each of these three members can be placed in ISNULL() as the first parameter and 0 as the second. If there is no data, instead of being Null, it will be treated as 0 and your calculation should work.

2 0

score 0 · Answer 1 · 2016-11-22T04:53:53-05:00

Benjamin Bryans · Nov 22, 2016

That works perfectly Peter, thank you!

0 0