2 Replies Latest reply: Dec 24, 2017 9:49 AM by pradosh thakur RSS

    SET expression instead of 1 can i enter 2016 ?

    Yeo Poh sai

      Hi Sir


      I have below expression working fine :-


      money(

      SUM({<year = {'$(=Max(year)-1)'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}$(ColumnDim51)/$(Columndim89)/1000)

      , $(vMoneyFormatK))



      Now if i change the


      Max(year)-1  it will display 2016 sales amount

      Max(year)-2  it will display 2015 sales amount

      Max(year)-3  it will display 2014 sales amount


      May i know how to change thw above expression , so that when i


      Max(year)-2016  it will display 2016 sales amount

      Max(year)-2015  it will display 2015 sales amount

      Max(year)-2014  it will display 2014 sales amount


      In another work , i need the SET expression to replace


      1 to 2016

      2 to 2015

      3 to 2014


      Paul