1 2 Previous Next 16 Replies Latest reply on Jun 28, 2017 8:47 AM by john gu

    Running total ending at current month but continuing in previous months

    Lucie Brett

      Hello forum!

       

      I have a running total calculated field which stops a cumulative line in the current month so that it doesn't continue into the future (I am comparing this year with previous years). However, the problem with my calculated field is that if there is a month with no records the line breaks. Does anyone have an idea on how I would fix this please?

       

       

      IF  sum([Number of Records]) = 0

      OR  isnull(sum([Number of Records]))

      THEN NULL

      ELSE running_sum(sum([Number of Records]))

      END

       

      Here is a screenshot of what is happening:

       

       

      Thanks in advance for your help! Lucie

        1 2 Previous Next