Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
May be this
Count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}, Status = {'in review','certified'}>}[LH])
May be this
Count({<Rev={'0*','1*','2*','3*','4*','5*','6*','7*','8*','9*','10*'}, Status = {'in review','certified'}>}[LH])
Thanks it worked.