Issue in chart

[#1]

Hi,

Can someone please help me with this requirement:

I want to remove the current month from my chart.

And my expression is

rangesum(above(sum(NetWorkDays([Fund Start Cycle],[Fund End Cycle])-1),0,12))

/

rangesum(above(count(NetWorkDays([Fund Start Cycle],[Fund End Cycle])),0,12))

Regards,
Sachin

[sunny_talwar]

May be this:

RangeSum(Above(Sum({<DimensionDateField = {"< $(=Date(Max(DimensionDateField), 'MMM YYYY))"}>}NetWorkDays([Fund Start Cycle],[Fund End Cycle])-1),0,12))

/

RangeSum(Above(Count({<DimensionDateField = {"< $(=Date(Max(DimensionDateField), 'MMM YYYY))"}>}NetWorkDays([Fund Start Cycle],[Fund End Cycle])),0,12))

[#3]

It didn't work!!!