count with condition "distinct"

[marqupcmb]

Dears I'm trying to count a text value if it is distinct to a specific value but it doesn't count

Im trying with this expression

=Count({<Status={'MTY'}, PoD={'<>PEPAI'}>} Container)

also tried with

If(Status='MTY' 
     AND PoD<>'PEPAI',
    Count(Container)
  )

Thanks

[sunny_talwar · Accepted solution]

May be this (Note a negative sign before 😃

=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)

[sunny_talwar]

Or

=Count({<Status={'MTY'}, PoD = e({<PoD = {'PEPAI'}>})>} Container)

[swuehl]

Or modifying your second expression (using a record based evaluation, which could perform worse than set analysis):

=Count( If( Status = 'MTY' and PoD <> 'PEPAI', Container))

[marqupcmb]

Thanks!! It works