Arithmetic Calculation
- Create the numeric constants that you want to use in the calculated field.
- Security:Custom Field Managementdomain in the System functional area.
You can set up the calculated field to derive values from currency or numeric fields by
performing these simple arithmetic calculations:
- Addition
- Subtraction
- Multiplication
- Division
Self-referencing fields cause exceptions with this calculated field. You can determine
if your calculated field is self-referencing by accessing from the related actions menu of the calculated field.
- Access theCreate Calculated Fieldtask.
- SelectArithmetic Calculationfrom theFunctionprompt.
- As you complete theCalculationtab, consider:
Option Description Field TypeIf you selectCurrency, all fields in the calculation must have the same currency code.RoundingUnless you select an option, Workday appliesround half upwhen there are 6 decimal places. Example: 2.123456 rounds half up to 2.124.Workday performs rounding after each set of division and multiplication, so a group of numbers might not add up to the total displayed.If theField TypeisCurrency, Workday doesn't perform any rounding.Currency Code FieldIf theField TypeisCurrency, specify a currency code, such as EUR or USD. TheCurrency Code Fieldand currency codes for the currency fields in the calculation must match.Return Zero on ErrorSelect the check box to return a zero value instead of displaying an error if the calculated field attempts to divide by zero.If you use a Prism business object with this calculated field, Workday always returns a zero on error. - As you complete theArithmetic Expressiongrid, consider:
Option Description ParenthesesYou can configure up to 9 levels of parentheses for calculations with:- Multiple operations.
- Operations requiring a specific order.
FieldAvailable field options depend on the business object that you select.
You can use arithmetic calculations to calculate a worker's:
- Daily, hourly, monthly, or weekly rate.
- Salary difference from this year compared to last year.
- Salary range penetration percentage.
You can create:
- Additional calculated fields.
- New calculated fields from within an arithmetic calculation calculated field.