Running Total

[Anonymous]

 

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

[TomMartens · Accepted solution]

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