Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
we are applying sum on Input value it is giving us double or triple value depending on available **** — Cloud Customer Connect
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

we are applying sum on Input value it is giving us double or triple value depending on available ****

Received Response
16
Views
1
Comments
edited Feb 22, 2021 6:38AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

element entry sum is doubling based on assignment history in OTBI

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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