3 Replies Latest reply: Jul 3, 2016 4:14 AM by PAUL YEO RSS

    How to add COUNTRY_={"Singapore"} & COUNTRY_={"CASH SALES"}  ?

    PAUL YEO

      Hi All

       

       

      I have 2 expression both are okay :-

       

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"Singapore"}>}sales/Rate)

       

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"CASH SALES"}>}sales/Rate)

       

       

      I like to conbine them into 1 expression , but cannot work :-

       

       

      Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year))}, sales = >} month))"},COUNTRY_={"CASH SALES"}+COUNTRY_={"Singapore"}>}sales/Rate)

       

       

      Can some one advise me.

       

       

      Paul