Skip to Content
0
Former Member
Jan 30, 2008 at 02:16 PM

Display number of working days

67 Views

Hi,

I need to return the number of calendar days in that period in a cell. I think I have to use BUCKET_WDAYS() fnction but I am unable to understand how to use it.

In the definition, I define BUCKET_WDAYS().

Also the SAP help says:

"BUCKET_WDAYS( <calendar> ; X1 ; ... ; Xn) returns the number of workdays in the periods given by the cell(s), row(s), and/or column(s) (not areas) X1 through Xn. In the attributes of the argument elements, you must specify Period data as the data source. The specification of a calendar as the first argument is optional. If you do not specify a calendar, the system reads the calendar given by the time stream in the storage buckets profile. If no time stream is defined, the system uses calendar days."

My real problem is I have calendar, ofcourse it's optional. Then what are X1 and Xn? Are they rows? I am trying to return the number of workdays in that period and why would I give more than one row here?

What does " In the attributes of the argument elements, you must specify Period data as the data source." mean?

Please let me know if I am not clear.

Thanks.

Edited by: Raj G on Jan 31, 2008 11:50 AM