2 Replies Latest reply on Mar 30, 2016 5:01 AM by Hannah Williams

    Multiple IFNULL clauses

    Hannah Williams

      Hi All


      I have a calc like this: IFNULL([Time], [Time 2]). It fills in an approximate date when there's a NULL, so that my time filter works on all rows.  However what I need to cover all basis, is multiple clauses for NULL's like this:


      IFNULL([Time], [Time 2])

      OR IFNULL([Time 2], [Time 3])

      OR IFNULL([Time 3], [Time 4])



      Is something like this possible?