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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Extract all values from Person Profile Content Type in single cell

edited Mar 8, 2018 6:43PM in Reporting and Analytics for HCM 1 comment

Summary

I want the entire contents of an employee's "Skills / Areas of Expertise" in one cell

Content

Hello

I'm looking for a way to combine everything an employee entered within a profile type, as a single cell, to fit along a single row.  Right now if I pull over profile items like "Achievements" or "Skills / Areas of Expertise" into a report I get a row for each Achievement or Skill.  Is there a formula I can use to combine all values from such fields, into one cell?  I'd prefer it be a formula NOT a pivot, as the scope of the report is to provide Talent Review facilitators information on an employees 2017 talent review as well high-level data

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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