working days

paulwalker — Wed, 25 Nov 2020 16:16:04 GMT

Re: working days

jyothish8807 — Sun, 17 Jun 2018 14:01:37 GMT

Try this:

IF(Division='Europe',

(

(SUM(AGGR(SUM(TOTAL <Month> {<Week=>} Budget), Month,Week)))/

NetWorkDays(MonthStart(MIN(OrderDate)), MonthEnd(Max(OrderDate)), Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')))

(NetWorkDays(MIN (TOTAL <Week> OrderDate), MAX(TOTAL <Week>OrderDate),Date#('01/01/2018', 'MM/DD/YYYY'), Date#('03/30/2018', 'MM/DD/YYYY'),

Date#('04/02/2018', 'MM/DD/YYYY'), Date#('05/07/2018', 'MM/DD/YYYY'), Date#('05/28/2018', 'MM/DD/YYYY'), Date#('08/27/2018', 'MM/DD/YYYY'),

Date#('12/25/2018', 'MM/DD/YYYY'), Date#('12/26/2018', 'MM/DD/YYYY')))

(SUM(TOTAL <Division>UnitCost)/5)

NetWorkDays(MIN(TOTAL <Week> {<Division>} OrderDate), MAX(TOTAL <Week> {<Division=>} OrderDate))

)