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

      I have 3 fields






      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