How to make sunny Expresssion with out RangeSum(Aboive ?

paulyeo11 — Thu, 21 Apr 2016 11:26:51 GMT

Hi All

I have this expression from Mr Sunny :-

RangeSum(

Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), 0, RowNo()))),

-Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), YearMonth)))

It work fine in QS , but not my QV ver 9. As i remember before , when i plot chart if i remove RangeSum(Above

the chart may able to give the correct value.

Hope some one can share with me how to remove the RangeSum(Above from above expression.

Paul

Re: How to make sunny Expresssion with out RangeSum(Aboive ?

paulyeo11 — Thu, 21 Apr 2016 11:28:20 GMT

my QV Doc