6 Replies Latest reply: Feb 13, 2018 1:12 PM by Mark Bustin RSS

    Help with set analysis syntax

    Mark Bustin

      Greetings,

      I need to filter actions that meet a few conditions, and I'm stuck on the syntax to test for the result of a Networkdays()  function that evaluates to less than or equal 20 days. I just cannot figure out the correct syntax, can someone please take a look?

       

      My formula is:

      Count({$<FOIAType={'Request'},Status ={'Closed'},ClosedDate = {">=10/01/2017"}, NetWorkDays(DateReceived,ClosedDate,$(vHolidays)) = {"<=" 20} >}TrackingNum)

       

      Thanks,

      Mark