1 Reply Latest reply: Apr 21, 2016 7:28 AM by PAUL YEO RSS

    How to make sunny Expresssion with out RangeSum(Aboive ?

    PAUL YEO

       

      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