Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this (Note a negative sign before 😃
=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)
May be this (Note a negative sign before 😃
=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)
Or
=Count({<Status={'MTY'}, PoD = e({<PoD = {'PEPAI'}>})>} Container)
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))
Thanks!! It works