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

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

    Hourly Rate Formula

    edited Oct 16, 2022 2:48PM in Reporting and Analytics for HCM 3 comments

    Summary:

    I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm looking for and would greatly appreciate your assistance.

    If "Salary Basis"."Salary Basis Name"='US HOURLY’ then "Salary"."Current Salary" else

    If "Salary Basis"."Salary Basis Name"='US ANNUAL' and "Salary"."Full-Time Equivalent" is not 0.00 then "Salary"."Annualized Salary"/26/"Worker"."Normal Working Hours" else

    If "Salary Basis"."Salary Basis Name"='US ANNUAL' and "Salary"."Full-Time Equivalent"  = 0.00 then  "Salary"."Annualized Salary"/26/8

    Expected Output Example:

    If there is a way to also write the formula with no rounding, that would be great.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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