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

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

Received Response
13
Views
5
Comments
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!