1 Reply Latest reply on Feb 10, 2016 4:05 PM by savinay sehgal

    Nested If else condition to filter subeset from a set

    savinay sehgal

      hello,

       

      I am using a data set which has list of issues by department. I have few calculated fields which segregate those issues in Over Due, Over Due < 16 days, Over Due > 15 & < 30 Days

       

      I am trying to add a filter in the sheet which would have these as categories and when user selects OverDue only issues that belong to that category would show up and subsequently for Over due <16 days, Over Due > 15 & < 30 Days

       

      However, the problem is that Over Due < 16 days is a sub set of Over Due and likewise Over Due > 15 & < 30 Days is also a subset of Over Due

       

      Here are the formulas for OverDue and Over Due < 16

       

      OverDue:

      IF  [Status]="OPEN"

      AND DATEADD('month',2,[Ticket Submit Date Time])  < TODAY()

      and NOT CONTAINS([How Was Issue Found - Calc],"ABC")

      and NOT CONTAINS([How Was Issue Found - Calc], "XYZ" )

      THEN

      [Incident ID]

      END

       

      Over Due < 16 :

      IF  [Status]="OPEN"

      and NOT CONTAINS([How Was Issue Found - Calc],"ABC")

      and NOT CONTAINS([How Was Issue Found - Calc], "XYZ" )

      AND DATEDIFF('day',DATEADD('month',2,[Ticket Submit Date Time]),TODAY()) <=15

      AND DATEDIFF('day',DATEADD('month',2,[Ticket Submit Date Time]),TODAY()) >=0

      THEN

      [Incident ID]

      END

       

       

      Thanks,

      Savi