1 Reply Latest reply on Apr 10, 2018 2:42 PM by Patrick A Van Der Hyde

    Excluding Bank Holidays from Data

    geryn.ligator

      Hello,

      I am using the calculation below to find the percent of days remaining in the month. I use all weekdays in my data and would only like to exclude bank holidays. Is there a way to do this?

       

      day(DATETRUNC('week',today()))

      /

      day(dateadd('day', -1, dateadd('month', 1, datetrunc('month', today()))))

       

       

       

      Thanks!