How to add year = {$(=Max(year)-1)} into my count expression ?

[paulyeo11]

Hi All

I have below expression work fine :-

count(distinct(company))

I want to add, below condition to above :-

year = {$(=Max(year)-1)}

I try :-

count(year = {$(=Max(year)-1)},distinct(company))

it does not work.

Paul

[paulyeo11]

my QVF file

[sunny_talwar · Accepted solution]

Have not looked at the sample yet, but try this:

Count({<year = {$(=Max(year)-1)}>} Distinct company)