

Contributor II
2017-01-24
10:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
count with condition "distinct"
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
1,026 Views
1 Solution
Accepted Solutions

MVP
2017-01-24
11:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this (Note a negative sign before 😃
=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)
4 Replies

MVP
2017-01-24
11:12 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be this (Note a negative sign before 😃
=Count({<Status={'MTY'}, PoD -= {'PEPAI'}>} Container)

MVP
2017-01-24
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Or
=Count({<Status={'MTY'}, PoD = e({<PoD = {'PEPAI'}>})>} Container)
826 Views


MVP
2017-01-24
11:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))
826 Views


Contributor II
2017-01-24
11:22 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks!! It works
826 Views
