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.
we are applying sum on Input value it is giving us double or triple value depending on available ****
Summary
element entry sum is doubling based on assignment history in OTBIContent
Subject Area = Payroll - Element Entries History Real Time
When running detail report, data is like below.
| Element Name | Input Value Name | Displayed Input Value |
| Overtime Double Time | Hours | 1 |
| Overtime Double Time | Hours | 13 |
| Overtime Double Time | Hours | 25 |
| Overtime Double Time | Hours | 4 |
| Overtime Double Time | Hours | 5 |
| Overtime Double Time | Hours | 6 |
Requirement is, we need output like below:
| Element Name | Input Value Name | Displayed Input Value |
| Overtime Double Time | Hours | 64 |
But when we are applying sum in OTBI then we are getting sum increased based on Assignment history available for employees.
1