How to split working days month and Year wise in pivot table

[Anonymous]

Hi All,

Please advice me. In one expression how to split working days per year and month. For example below is screen shot.

When i use networkdays in expression, days are not divided by month and year together. Aggregated value 1071 has shown for all years. Thanks to advice.

Regards,

Krishna Chaitanya B

[Anonymous]

Hi All, Expression "=NetWorkDays('01/01/2016','08/02/2016', $(vHolidays))" returns working days 25 considering vHolidays = '21/01/2016','01/01/2016'. But I would like to split Jan and Feb working days respectively 19 and 5 in a straight table. Please guide me how to achieve this. Regards, Krishna Chaitanya B

[sunny_talwar]

Is this as a dimension or expression? And is Month used a dimension?

[Anonymous]

Expression Sunny. Month is used as Dimension.

[Anonymous]

Try this for 2016 expression:

if(month = 'Jan',19,

if(month = 'Feb',20,

if(month = 'Mar',23,

if(month = 'Apr',21,

if(month = 'May',21,

if(month = 'Jun',22,

if(month = 'Jul',20,

if(month = 'Aug',23,

if(month = 'Sep',21,

if(month = 'Oct', 21,

if(month = 'Nov', 22,

if(month = 'Dec', 22)

)

))))))))))

Then modify the values for the expressions for 2017/2018

[Anonymous]

Mihai, this expression is of more static and hardcoading. I am trying to achieve it for three years and every year i cant update like that.

[Anonymous]

Maybe:

if(month = 'Jan',Networkdays('01/01/2016','31/01/2016',$(vHolidays)),

if(month = 'Feb',Networkdays('01/02/2016','29/02/2016',$(vHolidays)),

if(month = 'Mar',Networkdays('01/03/2016','31/03/2016',$(vHolidays)),

if(month = 'Apr',Networkdays('01/04/2016','30/04/2016',$(vHolidays)),

if(month = 'May',Networkdays('01/05/2016','31/05/2016',$(vHolidays)),

if(month = 'Jun',Networkdays('01/06/2016','30/06/2016',$(vHolidays)),

if(month = 'Jul',Networkdays('01/07/2016','31/07/2016',$(vHolidays)),

if(month = 'Aug',Networkdays('01/08/2016','31/08/2016',$(vHolidays)),

if(month = 'Sep',Networkdays('01/09/2016','30/09/2016',$(vHolidays)),

if(month = 'Oct', Networkdays('01/10/2016','31/10/2016',$(vHolidays)),

if(month = 'Nov', Networkdays('01/11/2016','30/11/2016',$(vHolidays)),

if(month = 'Dec', Networkdays('01/12/2016','31/12/2016',$(vHolidays))

)

))))))))))

and have in the vHolidays all the holiday dates for the said year?

[sunny_talwar]

How is Month and Year field linked to the two dates? Are you using IntervalMatch in the script?