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

[paulyeo11]

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

[paulyeo11]

my qvw

[antoniotiman · Accepted solution]

......,COUNTRY_={[CASH SALES],'Singapore'} .....

Regards,

Antonio

[paulyeo11]

Thank you sir