2 Replies Latest reply: Jun 29, 2017 9:18 AM by Felix Moran RSS

    Count items that fulfill criteria of 2 different fields.

    Felix Moran

      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,