4 Replies Latest reply on Jul 14, 2016 4:13 PM by ERIC MERRILL

    Expression Builder Help

    ERIC MERRILL

      Trying to calculate days which seems to be working fine when I simply subtract [actual_end_date] from [actual_start_date]

       

      However in some instances the [actual_end_date] is null.   When this happens I would like to pass the current date today().

       

       

      Here is what I have so far, I'm pretty new at this tableau thing...

       

       

      IF [ACTUAL_END_DATE] = 'NULL' THEN  [ACTUAL_END_DATE] = TODAY()

      ELSEIF  [ACTUAL_END_DATE] - [ACTUAL_START_DATE] END