2 Replies Latest reply: Jan 30, 2015 4:28 AM by Anand Chouhan RSS

    set analysis help

    Sri Priya

      Hi All

       

      Need a help in set analysis.

       

      we have a scenario

       

      Table1:
      Load * inline

      [

      D1                  , Key

      5/1/2015  , A

      6/1/2015, B

      7/1/2015, C

      ];

      And we have a calendar linked which has all dates.

       

      Need count(key) where (date selected - D1)>5

       

      Please help with the set analysis expression for this.

       

      Suppose date selected is 11/1/2015, count of key is 1, as

      11-5=6  for A

      11-6 = 5 for B

      11-7 = 4 for c

      Only for A, the difference is >5.

       

      Thanks.