Count Related Instances
Security:
Custom Field Management
domain in the System functional area.You can use the calculated field to count the number of instances in a related business object based on a condition. Workday counts only the instances that you have permission to view.
- Access theCreate Calculated Fieldtask.
- SelectCount Related Instancesfrom theFunctionprompt.
- On theCalculationtab, select a single instance or multi-instance option from theRelated Fieldprompt.
- In theCountsection, click:
- All instances.
- Instances where condition is trueto have Workday count only the instances that meet the specified condition.
You can count:
- Employees hired during the last year by location.
- Managers in an organizational unit in order to compute the management span of control.
- Open positions in an organization.
- Sick days occurring on Monday or Friday during the last year for each employee.
You can create a count related instances calculated field that provides a count of involuntary employee terminations in your organization.
Field | Value |
|---|---|
Business Object
| Organization |
Related Field
| Termination Events |
Count
| Instances where condition is true |
Instances where condition is true
| Is Involuntary Employee Termination |
You can create:
- Additional calculated fields.
- New calculated fields from within a count related instances calculated field.