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

Incorrect result in summary report for Payroll - Element entries history real time

edited Aug 10, 2021 6:06AM in Reporting and Analytics for HCM 5 comments

Summary

Incorrect result in summary report for Payroll - Element entries history real time

Content

For an employee, I am getting 8 records and the sum is 631.95

I have been required to summarize all element entries starting from 01/01/2020. Now I have removed the effective start date and end date column and add SUM function (SUM( Cast ("Element Entry Value"."Displayed Input Value" AS NUMERIC))) to the Amount field.

On Summation i am getting result Sum value is 4423.65

=4423.65/631.95 = 7

Not able to understand how 7 is getting multiplied.

Please suggest how to resolve this. My expectation is to get 631.95 as the sum of all values.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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