2 Replies Latest reply: Aug 30, 2018 9:17 PM by Chan Jonathan RSS

    Networkdays return me 2 records

    Chan Jonathan

      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

      holiday.png

      Next in the custom dimension, I added in my expression

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

      busniess days.png

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

      Final.png

      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.

      nodimension.png