5 Replies Latest reply: Oct 19, 2015 10:38 PM by Oscar Rodriguez RSS

    SET analysis don't need select month and year

    PAUL YEO

      Hi All

      Below are the script working fine , but hope some one can help me modify the below script , so that i don't require to select month = 9 , year = 2015 , meaning i want the script automatic give me the value , as i want to apply the script in QS.

       

      money(

      sum({$<year = {$(=max(year)-0)}

      ,[Reporting Code] = {

       

       

      ">=00001<=

      00019"

           }

       

       

      , month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} Amount/$(ColumnDim98))/1000

       

       

      , $(vMoneyFormatK_GL))