How to stop the "longtail" of a running total calc

Good morning all,

I am using 2018.1

I have created a running total so that analysts can see the values accumulate over time? See sheet named “Running Total”

What I don’t like about this view is the really long “tails” that the running total calculation shows.

So if you set up the view to show Fund 2019 in Fund 1 Value and Fund 2018 in Fund 2 Value you get this:

See how the blue line “flattens out” after July 2019? This is where I would want to stop the line.  I am thinking if I was to apply some logic that said “if the Fund 1 value was <> 0 then Fund 1 value” might work?

Open to your ideas and opinions on this.

Thanks,

Scott

null