11 Replies Latest reply on Sep 30, 2013 1:14 PM by Alex Welch

    Running Total not producing correctly

    Alex Welch

      I am struggling with this data set. I want the running total to all the way up to a certain point in 2013. The dataset is a record of the number of touchdowns peyton manning threw in his games. What I am running into is that when he did not throw a touchdown in a game, using the below equation, it is causing the running total to break. I understand why this is happening however I can't figure out how to get both a constant running total AND have it stop at a certain point in year 2013.

       

      IIF(COUNT([Rk])> 0,RUNNING_SUM(COUNT([Rk])),null)
      

      Tableau Public - manning_50_tds_2013-09-30_12-29-32.png

       

      Workbook: manning_50_tds