Hello,
I currently have two sets of data, one captures the biweekly hours worked the other captures production daily. I'm looking to calculate transactions per hr by pay period.
Example of biweekly data is 11/26/2020= 76hrs; 11/12/2020=80hrs. Shows the date the pay period ends
Example of production data 11/24/2020=15,11/25/2020=16
The current formula I have below doesn't exclude the production days in which the biweekly hours are yet to be captured.
Example the pay period ended 12/10/2020, but it is capturing transactions thru 12/09/2020, the formula needs to capture the transactions from 11/27/2020 thru 12/10/2020.
=((sum ({<[Date.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}disposedcount))+
(sum ({<[Date.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}drivercount)))
/
(sum ({<[Pay Period End.autoCalendar.Date]={">=$(=MonthStart (Today ()))<=$(=MonthEnd (Today ()))"}>}[Hours Worked]))
Thank you