Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'?
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.
Hi!
which is your Dimension?
If you dimension is Status, edit Dimension and try If(Status<>Cancelled,Status)
Ale
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
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