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

Calculated Sum of Gross pay

edited Apr 29, 2020 5:29PM in Reporting and Analytics for HCM 2 comments

Summary

need a new calculated value say Semester 1 (Jan-May) and Semester 2 (Aug-Dec). It should return the sum of the gross pay for all the pay periods falling under Jan-May and the same for Semester 2.

Content

Hi Team,

I need a new calculated value say Semester 1 (Jan-May) and Semester 2 (Aug-Dec). It should return the sum of the gross pay  for all the pay periods falling under Jan-May and the same for Semester 2. Could anyone please help me with this? Any help would be appreciated. 

I tried to group the months and the get the gross pay but as am using pay date field am not getting the aggregate value. If i don't use "pay date" field am able to get the sum but pay date field is mandatory.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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