Need inputs for Canada holiday lookback requirement for pay

Summary

Need inputs for Canada holiday lookback requirement for pay

Content

We have legislative requirement to pay for Holiday based on average pay of earlier 4 work weeks and we are facing difficulty in getting dimensions which can provide the pay details as we have semi-monthly payroll and don't have balances available based on weekly or daily basis. 4 work weeks might span across 2-3 pay periods depends on when the holiday is.

Any inputs from Canada payroll experts if this can be handled in cloud payroll and if yes then how?

Appreciate your help!