NetworkDays

[#1]

Hi,

I have attached the scaled down application.

I need to make pivot chart with dimension ISSUE_ASSIGNED_TO, KEY and expression which gives no of days between CREATED and DUE_DATE with considering holiday and weekends.

I tried networkdays with concat but results not coming.

Reg,

Shubhu

[Anonymous]

You can use a Calculated Dimension for this.
Like:

=IF((Holiday_Date)<>(CREATED) or (Holiday_Date)<>(CREATED) ,KEY )

But you have to make sure fields have the same format, because now they don't.

You have to use something like:

date(CREATED, 'DD-MM-YYYY')
date(FLOOR(CREATED))

Hope this helps.