Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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())
May be check no accumulation with this expression
=If(CanonMonthYear <= Today(), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))
May be check no accumulation with this expression
=If(CanonMonthYear <= Today(), RangeSum(Above(Sum(TrxnAmount), 0, RowNo())))
Thank you, Sunny - but that did not work.
YES YES.. that did work (I read it wrong first off)
Thank yoU!
Super