6 Replies Latest reply on Feb 13, 2019 9:35 AM by Shane Fife

    Make Table Calculations Empty for future

    Shane Fife

      Dear Tableau Community,

       

      I'm trying to get blank out all fields if the year has yet to come. (E.g., There won't be Fifth Year retention stats for the Fall 2017 cohort for quite some time).

      Most of it is controlled for, but for every other year after it'll show up.

      It must remain Table Down.

      I've tried as much as I could. I think it might be the order of the formula. See below.

      I've also attached the packaged workbook.

       

      Thanks!

       

       

       

      Formula for Graduate %, the remaining measure that shows up when it should be blank.

      IF

      RUNNING_SUM(

      [Graduate N])/

      WINDOW_MAX(COUNTD([IR]))=PREVIOUS_VALUE(1) THEN NULL

       

       

      ELSEIF

      RUNNING_SUM(

      [Graduate N])/

      WINDOW_MAX(COUNTD([IR]))=0 THEN NULL

       

       

      ELSEIF PREVIOUS_VALUE(1) = NULL THEN NULL

       

       

      ELSEIF LOOKUP(RUNNING_SUM(

      [Graduate N])/

      WINDOW_MAX(COUNTD([IR])),-1) = NULL

      THEN NULL

       

       

      ELSE    

      RUNNING_SUM(

      [Graduate N])/

      WINDOW_MAX(COUNTD([IR]))

      END