6 Replies Latest reply: Jun 21, 2017 9:01 AM by buck master RSS

    Set Analysys with date criteria's challenge

    buck master

      We have the following set analysys statements that return the same results?

       

      Return a count where start date + 30 is = or greater then finish date:

       

      Count ([WNUMBER]) - Count({< StartDT = 

      {">=$(=num(date#(StartDT +30)) =>num(date#(FinishDT)))"} >} [WNUMBER])

       

      Return a count where start date + 30 is = or less then finish date:

       

      Count ([WNUMBER]) - Count({< StartDT = 

      {">=$(=num(date#(StartDT +30)) =<num(date#(FinishDT)))"} >} [WNUMBER])

       

      Can anyone see why?

      Also, if i want to add additional criteria like: ,status={'C','P','A'}

       

      Thanks in advance