Skip to main content
Documentation
Documentation
Administrator Guide
Last Updated: 2023-06-23
Format Number

Format Number

Security:
Custom Field Management
 domain in the System functional area.
You can set up the calculated field to format a numeric field as a text field to:
  • Concatenate it with other text.
  • Use it as a notification.
  • Use it in a custom report.
  1. Access the
    Create Calculated Field
     task.
  2. Select
    Format Number
     for the
    Function
    .
  3. As you complete the
    Calculation
     tab, consider:
    Option Description
    Source Field
    Select a currency or numeric field associated with the selected business object.
    Format
    Select a format to apply to the resulting text field. Available options depend on your
    Source Field
     selection.
    Options
    Available options depend on your
    Source Field
     selection.
    Select
    Show Blank When Zero
     to display a blank value if a numeric field value is zero. If you use a Prism business object with this calculated field, Workday always returns a blank value.
Return values:
Source Field
Example Value
Format
Options
Value Returned by Format Number
Years of Service
12
#,##0.0
12.0
Total Base Pay Annualized - Amount
65,520.00
#,##0
Show Currency Symbol
$65,520
Total Base Pay - Payroll
6,166.666667
#,##0.00
Show Currency Code
6,166.67 USD
  • Create additional calculated fields.
  • Create new calculated fields from within a format number calculated field.