Skip to Content
0
Jul 12, 2006 at 06:35 AM

Workdays in Query

37 Views

Hello, I have the following request. In a query I have to show current day (calendar day - no problem), how many workdays we had so far and how many workdays the month has depending on the factory calendar (variable).

Example: 11.04.2006 (current day) 7 (workdays so far in april) 19 (total workdays of april).

and this depending on the factory calendar.

I guess I have to calculate it on the way to the cube in two different key figures, but with which FM? Or other ideas? and how to take factory calendar into account?

Thanks a lot

jg