0 Replies Latest reply: Mar 24, 2016 6:54 AM by PAUL YEO RSS

    How to convert Month_n to SET ?

    PAUL YEO

      Hi All

       

       

      I have below expression from Table 2 which is using Month_n and need to select current month and year :-

       

       

      money(

      sum({$<Month_n={$(=max(Month_n)-0)}, month=, year=>} $(ColumnDim51)/$(Columndim89)/1000)

      ,$(vMoneyFormatK))

       

       

      I like to change the above expression by using SET with don't need to select on current month and year. and it will return current month sales.

       

       

       

       

      Paul