Help! Does Not Equal in Set Analysis

[#1]

Hi - I am trying to exclude 'Accepted' from my end results table.

I have tried the following (whch isn't working for me:

Count({$<Type = {'MT Pipeline'}, [Max Review Reason] ={'*'}-{'Accepted'}>}Case)

In addition, I have also tried to use the -= function, but this doesn't work for me either...

Please can someone advise?

Thanks

[#2]

might have to get an example document up... set expressions are always an exercise in frustration.

[pennetzdorfer]

What results do you get, if you try James Wallers or my proposals?

Please post an example, that makes helping a lot easier

[#4]

Hey guys - apologies for not getting back to you - I managed to get this to work!

However, I do have another problem and wondered if anyone could help - I have an expression in a straight line table ONLY({$<Type = {'Hire Reject'}>}User), yet I want to move this to be a calculated dimension - however, when i do this, I receive the result //error in calculated dimension - even though it works as an expression...this is driving me nuts!

[jagan]

Hi,

Try like this

Aggr(If(Type = 'Hire Reject', User), User, Type)

or

just use Type = 'Hire Reject' in all you expressions in chart, calculated dimension has performance issues.

Regards,

Jagan.