Calculated Fields and Types

Calculated Fields and Types

Calculated fields are new field definitions that can be configured which in deed allows you to manipulate and derived values based on the existing data. Calculate fields must be associated with business object. Calculated fields can be created using Workday Delivered fields and custom fields as source. Calculated fields determined the value at run time.

Calculated fields can be categorized into 2 ways:

1. System-wide calculated fields

         They are created in a generic way by using the task - Create Calculated Field. They can be used in multiple reports.

2. Report specific calculated fields 
              They are created as part of one report and usage is specific to that report only. They are not reusable by other reports.

Below task allows you to convert System-wide Calc Field to a Report Specific Calc Field.

   Convert Calculated Field

Below task allows you to convert a Report Specific Calc Field to System-wide Calc Field.

   Convert Calculated Field for Report

Also check - Reports / Tasks Associated:

All Calculated Fields

Create Calculated Field

View Calculated Field

Delete Calculated Field

Edit Calculated Field

Maintain Calculated Fields for Report

Calculated Field Exception Audit

Calculated Field Usage Hierarchy

Maintain Calculated Fields

Calculated Fields Defined

Maintain Calculated Fields for Report

Recently Updated Calculated Fields

Report Specific Calculated Field Exception Audit

Calculated Fields - Acronyms

Calculated Fields - Acronyms

There are around 34 functions that you can use to create any calculated fields for any desired available BO. 

When trying to create a Calculated Field using one the available functions, while searching for desired function (in task Create Calculated Field ) you can simply type the acronym to find it.

Also notice the input field type (i.e. source field) and the Ouput Field type from each Calc Function below.

Calculated Field Function	Acronym	Input Field Type(s)	Output Field Type
Aggregate Related Instances	ARI	Multi Instance	Multi Instance
Arithmetic Calculation	AC	Numeric or Currency	Numeric
Build Date	BD	Date or Numeric	Date
Concatenate Text	CT	Single Instance or Text	Text
Convert Currency	CC	Currency	Currency
Convert Text to Number	CTN	Text	Number
Count Related Instances	CRI	Multi Instance	Number
Date Constant	DC	*Free Date Format	Date
Date Difference	DD	Date	Numeric
Evaluate Expression	EE	Any	Any
Evaluate Expression Band	EEB	Text	Single Instance
Extract Multi Instance	EMI	Multi Instance or Single Instance	Multi Instance
Extract Single Instance	ESI	Multi Instance	Single Instance
Format Date	FD	Date	Text
Format Number	FN	Number or Currency	Text
Format Text	FT	Text or Single Instance	Text
Increment or Decrement Date	IDD	Date	Date
Lookup Date Rollup	LDR	Date	Single Instance
Lookup Hierarchy	LH	Single Instance	Single Instance
Lookup Hierarchy Rollup	LHR	Single Instance	Single Instance
Lookup Organization	LO	N/A	Single Instance / Multi Instance
Lookup Organization Roles	LOR	N/A	Single Instance / Multi Instance
Lookup Range Band	LRB	Numeric or Currency	Single Instance
Lookup Related Value	LRV	Single Instance	Any
Lookup Translated Value	LTV	Text	Text
Lookup Value as of Date	LVD	Any	Matches Input Value Type
Numeric Constant	NC	*Free Number Format	Numeric
Prompt for Value	PV	Any	Matches Input Value Type
Substring Text	ST	Text or Single Instance	Text
Sum Related Instances	SRI	Single Instance or Multi Instance	Numeric
Text Constant	TC	*Free Text Format	Text
Text Length	TL	Text or Single Instance	Numeric
True/False Condition	TF	Any	Boolean