Set Analysis Not Equal expression

[Anonymous]

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

[joshabbott]

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'?

[DavidFoster1]

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.

[male_carrasco]

Hi!

which is your Dimension?

If you dimension is Status, edit Dimension and try If(Status<>Cancelled,Status)

Ale

[#5]

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

[SunilChauhan]

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