3 Replies Latest reply on Feb 23, 2018 9:39 AM by Laurie Suppes Branched to a new discussion.

    Running sum - not showing zero's when no new data is added to the running sum

    Laurie Suppes



      I am having an issue with running sum. I am creating a report that shows active employees dynamically and the issue I am having is that in months where no new employees were hired or terminated, the data is blank because there is no data. I would like for it continue to the previous data point and display the total carried over. I have show missing values checked. and I have tried if isnull formulas and ZN formulas with no success.


      Any thoughts or ideas are greatly appreciated!



      (tableau version 10.3.3)