working days

[jyothish8807]

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))

)