4 Replies Latest reply: Jan 30, 2018 11:09 PM by Yeo Poh sai RSS

    SET expression How to add one more condition ?

    Yeo Poh sai

      Hi All

       

      Below expression working fine :-

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

       

      I need to add one more condition to above expression , that is SOURCE = TDSS , So my expression as below :-

       

      Sum({$<year = {$(=Max(year)-1)},SOURCE = {"TDSS"}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = {'*'}>} month))"}>}sales/1000)

       

      But it display null. may i know where i go wrong ?

       

      Paul