British Columbia time off lookback

Hey everyone,

Looking at some help to setup new earning calculation for sick time off for BC which as per their ESA is

amount paid ÷ days worked

where

amount paid is the amount paid or payable to the employee for work that is done during and wages that are earned within the 30 calendar day period preceding the leave

I'm trying to setup the calc fields for the lookback but no luck yet. I'd appreciate feedback on how to set this up or if anyone has this in place share the CFs.

TIA