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.
Edited by: Raj G on Jan 31, 2008 11:50 AM