7 Replies Latest reply: Mar 31, 2016 11:09 AM by PAUL YEO RSS

    My SET expression work well in QV , but in QS it does not accumulated.

    PAUL YEO

      Hi All

       

      My SET expression work well in QV , but in QS it does not accumulated.

       


      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales)

       

       

       

      I mean if i select Feb 2016 , it will display only feb 2016 sales 122K is worng.

       

      it should display accumulated sales from jan till feb 2016 amount = 122 K + 18 K = 140 K

       

      if i dont select any yr and mth , it display correct value.

      Paul