3 Replies Latest reply on Feb 23, 2018 10:24 AM by Yuriy Fal

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

    Laurie Suppes

      Hello!

       

      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!

       

      Laurie

      (tableau version 10.3.3)