Concept: Calculated Fields in Supplemental Schedules

You can create calculated fields that you can use in Worksheets to:

Calculate the value for a currency or numeric column.

Calculate the translated currency value for roll forward.

Calculate Arithmetic Expression function.

See Concept: Calculated Fields .

When creating calculated fields for Supplemental Schedules, keep these guidelines in consideration:

You can only create a calculated field using the Arithmetic Expression.

You create the calculated field on the

Supplemental Data Row

business object.

In the

Field Type

prompt, select one of these 2 data types:

Currency

Numeric

If you specify

Currency

in the Field Type, you must specify a currency code in the

Currency Code Field

prompt as follows:

For creating a Calculated Field, select

Currency

For creating the respective Translated Calculated Field, select

Reporting Currency

When you configure a Supplemental Data template and enable

Roll Forward

, you must create a

Currency

data type of Calculated Field and its respective Translated Calculated Field. If you don't enable

Roll Forward

, configuring Calculated Field is optional.

The calculated field must match the data type of the column. Example:

For the

Currency

data type, you can only select a calculated field that returns a currency attribute value.

For the

Numeric

data type, you can only select a calculated field that returns a numeric attribute value.

For numeric calculated field results, Workday displays up to 6 decimal places.

For currency calculated field results, Workday adheres to ISO currency code standards to determine the number of decimal places. Example: If $10 ÷ $3 = 3.333333 (numeric), then $10 ÷ 3 = $3.33 USD (currency).

See Create Calculated Fields.