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.
Any assistance in this regard will be greatly appreciated.
asked Apr 11 at 02:59 PM in Default