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?
Need Help
  • TomMartens's avatar
    TomMartens
    8 years ago

    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

TomMartens's avatar
TomMartens
Super User
8 years ago

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