Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Running Total

 

Why does the running total continue even when there are no values in the left column? Is there any way to disable this?

  • Hey,

     

    the running total "runs" for all the dates you are "showing" in your table.

     

    You can avoid this if you put something like this around your calculation:

    IF(NOT(ISBLANK([yourbasemeasure]))
     ,[yourrunningtotalmeasure]
    )

     

    Regards

    Tom

1 Reply

  • Hey,

     

    the running total "runs" for all the dates you are "showing" in your table.

     

    You can avoid this if you put something like this around your calculation:

    IF(NOT(ISBLANK([yourbasemeasure]))
     ,[yourrunningtotalmeasure]
    )

     

    Regards

    Tom