Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Hourly Rate Formula — 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

Hourly Rate Formula

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


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.

Howdy, Stranger!

Log In

To view full details, sign in.


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