Time Filter

[neg177]

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 

[rob_marshall · Accepted solution]

@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.

Rob

[neg177 · Accepted solution]

Hi,

Got it, 

Thank you