18 Replies Latest reply: Jul 3, 2015 5:40 AM by Sasidhar Parupudi RSS

    Set analysis to exclude a record when a date field is blank

    Andrew Thomas

      I have 3 fields

       

      Actualdate

      Currentdelinquent

      scheduleddate

       

      At the moment I have the following expression that excludes all of the records where the currentdelinquent field is = null

       

            If(not isnull([completeddelinquent]),actualdate )

       

      This works but it also returns records where actual date is = to blank and I also want to exclude these records.

       

      I think I need to use set analysis combined with the formula above but can't get it to work