Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
4 years ago
Solved

Stopping Cumulative Total

Hi everyone, how can I stop my cumulative total on calculating when no actual values on subsequent days/months. I do have my date filtered in Year. Thanks in advance. Here are my two measures ...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    4 years ago

    ronaldbalza2023 , hope in this measure you have not added +0 or handled blank value using if

    Op Bal Interim Bank Transactions

     

    remove +0 or any blank handling

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
4 years ago

Hi amitchandak, It did the same thing as on my two measures. Was it because of my filter?

 

amitchandak's avatar
amitchandak
Super User
4 years ago

ronaldbalza2023 , hope in this measure you have not added +0 or handled blank value using if

Op Bal Interim Bank Transactions

 

remove +0 or any blank handling