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

Check for duplicate Position Codes using COUNT

edited Apr 5, 2019 11:22AM in Reporting and Analytics for HCM 4 comments

Summary

Show count of position code to identify duplicates

Content

Hi,

I am using the Position Real Time subject area and I'm trying to determine which position codes are appearing twice. The idea is to do a count of position code and then filter on count > 1 however the count is not working.

I only have two coluumns: "Position Details"."Position Code" and a formula column COUNT("Position Details"."Position Code")

I can clearly see some positions codes listed twice but the count is showing 1 for all. Any ideas?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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