Forum Discussion

Julier's avatar
Julier
Icon for Helper III rankHelper III
1 year ago
Solved

Running sum

Hello, Im hoping someone can help, How can I get this measure to leave the running total for the rest of the month blank if there is nothing in the ytd corresponding column, at the moment it fills in...
Need Help
  • MarkLaf's avatar
    MarkLaf
    1 year ago

    I think you can get this by just updating your visual calc like so:

     

    Running sum = IF( NOT ISBLANK( [YTD] ), RUNNINGSUM([YTD]) )

     

MarkLaf's avatar
MarkLaf
Icon for Super User rankSuper User
1 year ago

I think you can get this by just updating your visual calc like so:

 

Running sum = IF( NOT ISBLANK( [YTD] ), RUNNINGSUM([YTD]) )

 

  • Julier's avatar
    Julier
    Icon for Helper III rankHelper III
    1 year ago

    This worked like a dream, thank you !