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

Fast Formula to calculate standard earnings for an employee given a date range

edited Sep 18, 2020 10:59PM in Compensation 3 comments

Summary

Fast Formula to calculate standard earnings for an employee given a date range

Content

I need a Fast Formula to calculate standard earnings for an employee given a date range for a "compensation default and override" formula in my bonus plan sheet.  We are using Oracle Payroll. 

Inputs

  • employee number
  • start date (dynamic column calculated prior to calling this)
  • end date (dynamic column calculated prior to calling this)

Does anyone have one, or should I raise an SR?  Or is there an Oracle doc?

Scenario - employee switches positions and salary during the year

Employee gets promoted with a salary increase effective April 1

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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