Time Filter

Highlighted
Regular Contributor

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 

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: Time Filter

@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

Highlighted
Regular Contributor

Re: Time Filter

Hi,

 

Got it, 

 

Thank you