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