1 Reply Latest reply: Apr 1, 2016 11:21 PM by PAUL YEO RSS

    SET expression add filter COMPETITOR=wago

    PAUL YEO

      Hi All

       

       

      I using button to select only 4 company :-

       

       

      COMPETITOR

       

       

      (WAGO|PRECICON|iTDS|TDS_G|INTERMECH)

       

       

       

       

      I need to insert filter expression into below SET expression :-

       

       

      sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000

       

       

       

       

      My approach :-

       

       

      In the past i can insert filter less then current year.

      money((Sum({<year = {"<=$(=Year(Today()))"},      $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000), $(vMoneyFormatK))

       

       

      So i assume expression as below :-

      sum({$<year = {">=$(=max(year),4)"},COMPETITOR='WAGO'and'PRECICON', month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000

       

       

      But not work.

       

       

      Paul