Networkdays return me 2 records

[blurrblurr]

Hi,

I am new to this. just started 1 week ago.

I am try to customized a Dimension for Working days which exclude Weekends and holidays. I loaded an excel source with Holiday

Next in the custom dimension, I added in my expression

= networkdays (NCR_CREATE_DATE, NCR_CLOSE_DATE,Holiday_Date.autoCalendar.Date) - 1

But I am getting double record. Like to know what happen and how do I do troubleshoot?

Between create date to close date, there are 3 holidays. the correct days is 50 days. but why is 49 days appearing?

once I remove the custom working days dimension, it shows me only 1 record.

[william_fu · Accepted solution]

I think your problem is that you're actually only using a single Holiday_Date as an argument in your NetworkDays expression, instead of the entire list of your dates separated by commas

What I found is that you should create a variable in the script that concatenates all your holiday dates, and then use that as a parameter for NetworkDays:

tmpConcat:
LOAD concat(chr(39) & Holiday_Date & chr(39),',')             as HolidayDates
RESIDENT Holidays;

Let vPublicHolidays = fieldvalue('HolidayDates',1);

See: Find Net Working Days

[blurrblurr]

Yes Thanks! I got it