
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Set Analysis Not Equal expression
hi,
I am trying to exclude all values where Status is equal to Cancelled.
I tried both of these but couldn't exclude.
=count({$<[Contract Duration]={'no end date'}, [Status]={'*'}-{'Cancelled'}>}DISTINCT [Contract No])
=count({$<[Contract Duration]={'no end date'}, [Status]-={'Cancelled'}>}DISTINCT [Contract No])
Regards,
aamertaimor

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Both of those look correct to me. Any chance you can upload a sample? Is it possible the Status is actually spelled with only 1 'l'?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
The second should work nicely. I would suggest that there is a mismatch between your data and the set analysis. The 'contract duration' field would suggest a number not a string. Double-check capitalisation as well.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi!
which is your Dimension?
If you dimension is Status, edit Dimension and try If(Status<>Cancelled,Status)
Ale

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Just out of curiosity did If () work, like
Count(If([Contract Duration]='no end date' and Status<> 'Cancelled'), Distinct [Contract No])
Also if you could attach a sample file it will be much easier to debug.
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
copy value from Status as Cancelled and paste to above expressions.might be there is some space in Status column
or
take two list box one for
[Contract Duration] and select no end date and then see in [Status] weither there is Cancelled in white or grayed out
if it is grayed out means there is no combination of noend date and Cancelled.
and hence no result
hope this helps
