6 Replies Latest reply: Mar 3, 2016 7:20 PM by PAUL YEO RSS

    Expression work in QS but not work in QV

    PAUL YEO

      Hi All

       

       

      I have below expression work fine in QS :-

       

       

      Aggr(

      Rangesum( Above(

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      sales/1000)

      ,0,rowno()))

      ,year,(month,(NUMERIC,ASCENDING)))

       

       

       

       

      When i use the above same expression to QV , it does not work , When i remove the Aggr(

      Rangesum( Above( and it work fine ( ref to chart 1 ) :-

       

       

      Sum(

      {<Year={'>$(=year(today())-2)'}>}

      sales/1000)

       

       

       

       

      May i know why ?

       

       

      Paul