Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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