Calculate the SUM of the NULL Values in MDX

Hello I would like to calculate the number of working days, where nothing happened. Similar to calculating the number of days where there were no sales, but I would like to exclude Saturdays and Sundays from the equation. This will tell me how busy my store is and which days it isn't busy. I have managed to identify "somewhat" the values, but now I need to SUM them, and feel that my scope is not right in order for the aggregate to work on the level that I need it to. In the screenshot below, you'll see that if I show .ALLMEMBERS, then I can see the days that I need to add for the month by the "1" that I've put in my IIF statement by flagging the NULL values. What I now need to do is SUM them, so that when I go up a level and look at things in a [Month] level, then it aggregates all those values. ![alt text][1] Any assistance in this regard will be greatly appreciated. [1]: /storage/temp/4592-mdx1.png

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oleg commented · Apr 12, 2018 at 05:16 PM

@carelg It is not easy to figure out what you would like to actually happen from the screenshot. Posting the original query as text (not as image) and proving desired results in addition to the screenshot would help.

0 ·