Working days calculation

    Here is the expression to select count the number of working days from a Island working days calendar, where dates are selected in the transaction date dimensions

     

     

    =Sum({1< WorkYear={$(=If(GetSelectedCount(Year) > 0 OR GetSelectedCount(YearMonth) > 0 OR GetSelectedCount(MonthYear) > 0,

         Concat(DISTINCT Year, ','), '*'))},

        WorkQuarter={$(=If(GetSelectedCount(Quarter) > 0, Concat(DISTINCT DeliveryDateQuarter, ','), '*'))},

        WorkMonth={$(=If(GetSelectedCount(Month) > 0, Concat(DISTINCT Month, ','), '*'))},  

        WorkWeek={$(=If(GetSelectedCount(Week) > 0, Concat(DISTINCT Week, ','), '*'))},

        WorkingDay={$(=If(GetSelectedCount(Day) > 0 , Concat(DISTINCT Day, ','), '*'))}

        >} WorkDay)

     

    Regards,

    Jagan.