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

Visit Redwood Community
Need help to Payroll Employee Deduction BI report — 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

Need help to Payroll Employee Deduction BI report

Received Response
12
Views
7
Comments

Summary:

Report Parameter

1)    Person Number

2)    Element Name

3)    Period

4)    Pay Period Start Date

5)    Pay Period End Date

Report Column

·      Person Number

·      Person Name

·      Element Name

·      Modified Date

·      A Deduction Amount

·      B Deduction Amount

·      Begin (Effective Start Date)

·      End (Effective End Date)

In the parameter Pay Start Date, I have to give the 01 April 2022 and Pay End Date to provide the 15 April 2022 which means A deduction amount means from the 01Apr-15Apr amount and B deduction amount means from 16Apr-30Apr amount. So I cannot add the Parameter (Period, Pay Start date, and Pay End date) in my report. Below I provide the query of my report. Can anyone help me with how can I add this three-parameter(Period, Pay Start date, Pay End Date) in my below query

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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