Incorrect result in summary report for Payroll - Element entries history real time
Summary
Incorrect result in summary report for Payroll - Element entries history real timeContent
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:
0