Average Holiday Pay - Skipping Periods in Calculation

Summary:

We are looking to deliver a solution to comply with average holiday pay in the UK, whereby we can look back for 12 months of earnings up to a maximum of 24 months, skipping periods which do/do not hit certain critera

Content (required):

The requirement is for an average holiday pay calculation to calculate either an hourly or daily rate, by using pay information from 12 previous months, however this is not necessarily the last 12 months, it is the previous (up to) 12 months where there has been no absence taken and no overtime earned - we can deliver a solution which refers to the previous 12 months, but the struggle is to find logic which pulls 12 eligible periods from a possible 24, and where there are less than 12 eligible periods, adjusts the calculation of the average accordingly