7 Replies Latest reply: Sep 12, 2017 6:32 AM by Andrew Walker RSS

    Straight Table / Aggr or Set Analysis help

    Darren Dixon

      Hi

      Please could you help  I want to find the minimum Date where Description is not equal to Ignore.

      I think I need to use the aggr function or set analysis but I'm struggling to make this work.

       

      Table:

      PSNDateDescription
      188018631/12/2199Ignore
      188018624/07/2015Yes
      188018624/07/2015Yes
      188018607/05/2017Yes
      188018607/05/2017Yes

       

      I'd like the straight table to look like this:

      DatePSN
      24/07/20151

       

      I've got as far as:

      Count(Distinct

      IF([Description]<>'Ignore',

      [Date],))

       

      Thanks,

      Darren