The Substring Text function is a type of calculated field in Workday Reporting used to extract a specific portion of a text string. To group employees by area code, you must first isolate the area code from the full phone number field. Substring Text allows you to specify the starting character and the number of characters to extract, making it the correct tool to pull the area code (e.g., the first three digits) from the complete phone number string.

B. Format Number: This function is used to change the display format of numeric data (e.g., adding currency symbols or decimal places), not to extract a portion of a text string.

C. Format Text: This function changes the case of a text string (e.g., to uppercase or lowercase). It does not extract a part of the string.

D. Concatenate Text: This function combines two or more text strings into a single string. It is used for joining text, not for extracting a portion of it.

1. Workday Community Documentation: Calculated Fields: Reference Guide. The guide details various calculated field functions. The section on "Text Functions" explicitly describes Substring Text as the function to "return a portion of a text string

based on the character position you specify."

2. Workday Training Courseware: Reporting: Calculated Fields. In the module covering Text Manipulation functions

the Substring Text function is presented with use cases

including extracting specific segments from formatted identifiers like phone numbers or employee IDs. The documentation specifies its parameters: Source Field

Start Position

and Length.