Workday Calculated Fields
Introduction
Calculated fields are new field definitions that you can configure that allow you to manipulate, transform, retrieve, and derive values based on existing data.
You can use calculated fields to:
-Perform date calculations and formatting.
-Perform math calculations.
-Manipulate text with concatenate, substring, and formatting functions.
-Convert currency fields.
-Derive range bands from numeric or currency fields.
-Determine if a condition is true or not.
-Drilldown and lookup levels and values in hierarchies and organizations.
-Sum, count, and aggregate information across related instances.
-Lookup values in related objects.
Characteristics of calculated fields
-Calculated at runtime
-Associated with business object
-Based on existing data
Calculated field functions
Aggregate Related Instances
Arithmetic Calculation
Build Date
Concatenate Text
Convert Currency
Convert Text to Number
Count Related Instances
Date Constant
Date Difference
Evaluate Expression
Extract Multi-Instance
Extract Single Instance
Format Date
Format Number
Format Text
Increment or Decrement Date
Lookup Date Rollup
Lookup Field with Prompts
Lookup Hierarchy
Lookup Hierarchy Rollup
Lookup Organization
Lookup Organizational Roles
Lookup Range Band
Lookup Related Value
Lookup Translated Value
Lookup Value as of Date
Numeric Constant
Prompt for Value
Substring Text
Sum Related Instances
Text Constant
Text Length
True/False Condition
How to Create Calculated Field:
To create system-wide calculated fields, use the Create Calculated Field task.
There are three basic steps to create a calculated field:
1. Enter Initial Information
-> Provide a Name
-> Select a Business Object
-> Choose a function
2. Calculation Tab
-> Specify the parameters. Parameters vary depending on the calculated field function selected.
3. Additional Information Tab
-> Specify, as needed, to help organize, document, locate, and reference your calculated field.
No comments:
Post a Comment