13 Replies Latest reply on Mar 17, 2016 2:54 PM by muniyappan.m

    Multiple Filter on date column (Same): cond - when date is blank and date > eom

    muniyappan.m

      Hi

      Can some one advise me how to carry out this - Need to multiple filter on a same dimension

       

      Closed Date is blank or Closed Date > EoM.I have created calc field using IF condition but thats not working.Please advise me how to use formula in the filter .

       

      Dimension

      Closed date  - date coulmn

      8/07/1870

      30/12/1899

      5/05/1904

      16/01/1929

      18/02/1930

      13/10/1957

      2/03/1958

      1/05/1967

      27/09/1969

      Eom - Calculated date column

      31/12/1927 12:00:00 AM

      31/08/1928 12:00:00 AM

      30/11/1928 12:00:00 AM

      31/01/1930 12:00:00 AM

      31/10/1930 12:00:00 AM

      28/02/1986 12:00:00 AM

      31/05/1987 12:00:00 AM

      30/06/1987 12:00:00 AM

      30/06/1990 12:00:00 AM

      31/05/1992 12:00:00 AM

      30/06/1992 12:00:00 AM

      31/07/1992 12:00:00 AM

      31/08/1992 12:00:00 AM

      30/09/1992 12:00:00 AM

      31/10/1992 12:00:00 AM

      30/11/1992 12:00:00 AM

      31/12/1992 12:00:00 AM

      31/01/1993 12:00:00 AM

      28/02/1993 12:00:00 AM