You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

CONCAT Area Code and Phone Number

edited Feb 22, 2018 2:50PM in Reporting and Analytics for HCM 5 comments

Summary

I want to combine an employees work, home, and cellular phone number so area code isn't a seperate column

Content

Using this forum topic https://cloudcustomerconnect.oracle.com/posts/2c226a667a I was able to use CASE statements to show all of an employees phone numbers in a single row.  Big shout out and appreciation to Caroline specifically - I used her method and formulas which worked perfectly.  Now what I'd like to do is combine the area code with the different phone numbers so I do not have to have area code as a separate column.  I'd like to add these to each of the phone types I have listed.  I've tried using the CONCAT formula but I had no such luck.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!