SET expression add filter COMPETITOR=wago

[paulyeo11]

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

[paulyeo11]

my QV Doc