cancel
Showing results for 
Search instead for 
Did you mean: 

Workdays in Query

joerg_baumann
Explorer
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Use the function module RKE_SELECT_FACTDAYS_FOR_PERIOD ???

      • assign points if useful ****

Thanks,

Raj