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
Skip to content
  • Register
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    How to find the max value across multiple columns?

    in Reporting and Analytics for HCM 3 comments

    Summary:

    Staff can enter up to 6 qualifications in separate flexfields in the UI.

    We have a requirement to report on the highest value code entered for each employee. As you will see from the image below, the highest code could be in any order across the 6 fields as there are no entry restrictions in the UI.

    How can we identify the highest value code for each employee across the multiple columns?

    Content (required):

    Version (include the version you are using, if applicable):

    23A

    Code Snippet (add any code snippets that support your topic, if applicable):

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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