Time Filter

Need advice best way to set up a Time Filter in my Daily Model that gives me only the Weekdays and not the Weekends. Please Advice. 


Thank you 

Best Answer

  • @neg177 

    DayofWeek() will be your friend here.  That will return a number.  Create a line item for Weekdays with the formula: if DayofWeek line item < 6 then 1 else 0.