Min point work , Max point not working

[paulyeo11]

Hi All

I have a GP % chart.  the dynamic min GP% working fine and max GP% not working :-

Below is my min dynamic GP% expression :- ( working )

Min(Aggr(( sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1   - sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1  ) / sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),$(ColumnDim_p)

)

Below is my max dynamic GP% expression :- ( working )

Max(Aggr(( sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1   - sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} cost)/1  ) / sum({$<year=, month=, date = {">=$(=MonthStart(vSelectedDate, -48))<=$(=vSelectedDate)"}>} sales)/1),$(ColumnDim_p)

)

Notice that the major diff are the first wording of the expression , the rest should be same. But it just cannot work.

After typing till here , when i click the Static max to un-tick , it work fine. so in conclusion , the max value don't need to control.

Thank for viewing.

Paul