Help me build a calculated field for bonus eligibility based on location and tenure.
Summary
To build a calculated field for bonus eligibility based on location and tenure, you would combine several calculated field types.
First, define the tenure condition. This can be done by calculating the worker's tenure (e.g., years from hire date to today) using a Date Difference function, then defining the required tenure range with an Evaluate Expression Band or True/False Condition. Alternatively, for a more detailed tenure calculation based on "active days" during a fiscal year, you would determine employment start and end dates within the fiscal year using Evaluate Expression fields, calculate the difference with Date Difference, and then subtract any days on Leave of Absence (calculated similarly and summed using Sum Related Instances) using an Arithmetic Calculation.
Second, define the location condition by creating a True/False Condition calculated field that specifies the bonus-eligible location(s).
Finally, combine these conditions by creating a final calculated field (such as an Evaluate Expression or Condition type) that returns true only if both the defined location condition and the defined tenure condition are met.
Labels
Retrieved from Experts
To build a calculated field for bonus eligibility based on location and tenure, you would combine several calculated field types:
Calculate Tenure:
Create a calculated field using the Date Difference function to determine the worker's tenure (e.g., years from hire date to today) .
Then, create a second calculated field using the Evaluate Expression Band function or a series of True/False Condition functions to define the required tenure range for bonus eligibility .
Define Location Condition:
Create a True/False Condition calculated field where the condition is "Location equals a specific value" for the bonus-eligible location(s) .
Combine Conditions:
Create a final calculated field (e.g., an Evaluate Expression or Condition type) that returns true if both the defined location condition and the defined tenure condition are met.
Retrieved From Workday Documentation
From Customers
It is not possible to provide a complete answer for building a calculated field for bonus eligibility based on location and tenure, as the provided context does not contain information on incorporating "location" into such a calculation.
However, the context does provide guidance on building calculated fields for bonus eligibility based on "active days" (tenure):
1.8
To calculate the number of active days (days employed minus days on Leave of Absence) during a fiscal year for bonus eligibility, you would need the following calculated fields:
True False: If hire date is after fiscal year start date* and not after fiscal year end date* then return hire date. Else return fiscal year start date*.
True False: If termination date is after fiscal year start date* and not after fiscal year end date* then return termination date. Else return fiscal year end date*.
True False: If first day of leave is after fiscal year start date* and before fiscal year end date* then return First Day of leave. Else return fiscal year start date*.
True False: If Last Day of Leave - Actual is not blank, AND Last Day of Leave - Actual is after fiscal year start date* and not after fiscal year end date* then return Last Day of Leave - Actual. Else return fiscal year end date*.
*Note: For a report that can be used for other date ranges, you can use "Prompt - Start Date" and "Prompt - End Date" fields in place of the Fiscal Year Start and End dates. Dynamic prompt values can then be used to insert the fiscal year start and end dates or other date ranges.
1.3.1,