question

carelg avatar image
carelg asked

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
ssasmdx
mdx1.png (34.0 KiB)
1 comment
10 |1200

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

@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 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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