Assign working days to months

[Anonymous]

I have a pivot table in which I have months(dimension) attributed to each work cycle. My months already change dynamically by selecting a work cycle from the multi-box. Is there any way I can assign the working days values to each month, in an expression, without using about 12 nested ifs?

[marcus_sommer · Accepted solution]

I suggest to do this assigning within the script in a master-calendar with something:

if(weekday(Date) < 5, 1, 0) as WorkingDay

and this new field could be easily queried with somehing like: sum(WorkingDay)

Also possible are calculations with networkingdays() within the UI.

- Marcus

[Anonymous]

Thanks for the idea