1 Reply Latest reply: Aug 17, 2016 3:37 AM by Gysbert Wassenaar RSS

    How can I create a Project status filter based on Billable Hours for a rolling 3 months?

    Matthew Olds

      I am trying to create a filter that determines the following:

      If a project has greater than 0 Billable Housr within the last rolling 3 months, then the project is Active

      If a project has 0 Billable Hours within the last rolling 3 months, then the project is Inactive

       

      How would I go about this? Do I need to build an Expression that states that if Project Billable Hour is > 0, then 'Active', and if Project Billable Hour is 0, then Inactive.

       

      I'm a pretty novice user so any advice/ direction would be helpful