Work days

Description

If you need to report how many days a resource has worked, then the Work Days calculation is for you. JD Edwards allows one to define various work day patterns. The problem is that this information can be difficult to utilize in a report. The Work Days calculation simplifies the information so that you can get relevant information into your report such as:

  • Work days, holidays, or weekends per month
  • Whether a given day is a weekend, holiday, or weekend
  • Work days, holidays, or weekends per year
  • Calculate by branch plant and default branch plan
  • Calculate by shift

Calculation Editor

Options

Input Parameter Values Input Values
Work date(s) Input a single date or Any valid date range using the range notation. e.g. >=1/1/2017:<=12/13/2017 or <6/1/2016, etc. When this field has a valid range, it overrides any other date specification setting and the WorkDay calculation uses this date range to compute the workday count.
Branch Typically the grid column value for a business unit. This will be the branch that the calculation uses when looking up the work day information.
Default Branch If no branch is specified or if it has a blank grid column value, then use this value.
Year Four-digit year that represents the year you are interested in getting the workday information for.
Month 0=all months, 1 = jan, 2 = feb ... 12= dec.
Day of the Month 0=all days in month, 1 = day one ... 31 = day 31.
Shift Valid shift code (F0007.SHFT). Default is blank for no shift code.
WorkDay code W=workday, E=weekend, H=holiday. Default is workday (W).
Calendar Type Valid calendar type (F0007.WDCT). Default is blank for no specific type.
Calendar Key Valid calendar name (F0007.WDCK). Default is blank for no name.
Only Rollup If Generic Criteria

Examples

Example 1 - Identify Work Days

Let's say you want to identify if any of your invoice dates are non-work days which would be an anomaly to be called out.

To do this, you can utilize the work days calculation.

  1. Start by going to Design > Calculations > Work Days
  2. For the input Work Day(s), change Column as Filter to Column and link in Invoice Date
  3. Link Branch to your Branch Plant or Business Unit column with MCU alias
  4. Type *ALL into the Default branch literal input
  5. Save and Close the calculation to see 1's returned anywhere the invoice date is a work day.

Any instance of 0 means that the date code for that specific date is not equal to "W" which means it could be an "E" for weekend, "H" for holiday or something else.

Example 2 - Determine the number of work days between two dates

Let's say you want to identify the number of work days between your due date and invoice date in order to understand the average amount of days between the two.

To do this, you can utilize the work days calculation.

  1. Start by going to Design > Calculations > Concatenation
  2. Create a concatenation that connects these four elements with the name "Date Range"
    1. Literal value of >=
    2. Column of Invoice Date
    3. Literal value of :<=
    4. Column of Due Date
  3. Select Save on your Calculations Window
  4. Create a Work Days calculation next
  5. For the input Work Day(s), link the "Date Range" concatenation column you just created
  6. Link Branch to your Branch Plant or Business Unit column with MCU alias
  7. Type *ALL into the Default branch literal input
  8. Save and Close the calculation to see the number of days between the two dates. For positive values, the earlier date will go first in your concatenation.