Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
)