Count items that fulfill criteria of 2 different fields.

[#1]

Hello,

so far I was counting items fulfilling criterias on 1 field.

But now I need to count items fulfilling criterias on 2 fields.

Can any body helps please?

This was counting items of LH, that fulfills the criterias on field Rev.

count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}>}[LH])

Now I need something that makes the same but fulfilling in addition on the field Status the different Statuses {'in review','certified'}

With this I want to exclude all items which have the Rev numbers defined but are with a wrong status "obsolete".

Please I need the formula the soonest possible,

Thanks for the help,

[sunny_talwar · Accepted solution]

May be this

Count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}, Status = {'in review','certified'}>}[LH])

[#3]

Thanks it worked.