Charts: Showing cumlative budget vs spend-to-date

[#1]

I have been able to get a chart that includes cumulative total for Budget, Forecast and Spend (Paid). However - I want the Spend (Paid) bars to END with the current month. I want the blue bars (in the chart below) to STOP at the current month. I will list below all the things I have tried that have NOT worked.  For the chart shown a simple sum was used and Full Accumulation was checked:

These have NOT worked (each line used independently):

sum(TrxnAmount)

=aggr(sum(if(Date(CanonMonthYear,'MMM-YYYY')<=Today(),TrxnAmount,null())),CanonMonthYear)
=sum(IF((TrxnDate <= CanonDate), TrxnAmount))

=if(CanonMonthYear<=Today(),Sum (TrxnAmount),null())

[sunny_talwar · Accepted solution]

May be check no accumulation with this expression

=If(CanonMonthYear <= Today(), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))

[#3]

Thank you, Sunny - but that did not work.

[#4]

YES YES.. that did work (I read it wrong first off)

Thank yoU!

[sunny_talwar]

Super