Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2024-09-20
Concept: Calculated Fields in Supplemental Schedules in AP&C

Concept: Calculated Fields in Supplemental Schedules in AP&C

You can create calculated fields in Adaptive Planning and Consolidation (AP&C) 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.
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).