Convert Text to Number

Security: Custom Field Management
domain in the System functional area.

You can set up the calculated field to convert a text field number to a numeric value so you can perform calculations on that number. Example: You can convert a text field with a value of 200 expense lines
to the number 200
.

Access the

Create Calculated Field

task.

Select Convert Text To Number
for the

Function

As you complete the

Calculation

tab, consider:

Option	Description
Text Field	You can select either a single instance or a text field to convert to a number. If you select a single instance field, Workday uses the display ID value of the field.
Decimal Separator	Select the symbol that indicates a separation between the whole number and the fraction, such as a comma or a period. Example: When you select Based on user’s locale and the Text Field is 123.4 , where the period is the decimal separator, Workday computes the value as 1234 for regions that use commas as decimal separators.
Return Zero on Error	Select the check box to return a zero value instead of displaying an error if the calculated field returns non-numerical data. If you use a Prism business object with this calculated field, Workday always returns a zero on error.

(Optional) In the

Advanced

section on the

Additional Info

tab, select the

Do not use Alternate Display ID

check box from the

Options

prompt.

Instead of using the alternate display ID, Workday uses the display ID from the text source to convert the text to a number.

You can use the convert text to number calculated field to convert these texts into numeric values to perform arithmetic calculations on:

A worker's length of service in years.

The 200 rows in an expense report.

Create:

Additional calculated fields.

New calculated fields from within a convert text to number calculated field.

Concept: Calculated Fields

Create Calculated Fields