Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
formula to combine Primary and all Secondary locations into one field? — Cloud Customer Connect
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

formula to combine Primary and all Secondary locations into one field?

Received Response
50
Views
2
Comments
edited May 13, 2013 11:51AM in Reporting and Analytics Taleo Enterprise 2 comments

Content

I am not a reporting guru...so I'm hoping somebody can help me out with this!

We often post requisitions for more than one location.  When we want to pull all of the locations into an XIR3 report, we end up with multiple rows per requisition, if there's more than one Secondary location.  First row give Primary location plus first Secondary location.  Second row gives Primary location plus second Secondary.  Third row gives Primary location plus third Secondary.  And so on.  This is problematic, because the same one requisition gets counted several times in our stats.

I'm sure there must be a way to create a formula that will combine all the locations together in one field, separated by semi-colons or something.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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