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?

       

      Thanks