exclusion expresion

[#1]

If i want to include in my chart, this expresión:

sum {$<[Consortium]={'xxxx'},[Agency]={'55302472','55868995'>}NUM_PAX_BKD_LB )

And also the opposite: I mean, all the ones that belongs to Consortium 'xxx' but Agency='55302472','55868995'.

If i try this:   ({$<Weeks=,[Consortium]={'xxxx'},[Agency]<>{'55302472','55868995'>}NUM_PAX_BKD_LB )

Doesnt work.

Could someone help me?

Thanks!

[ashfaq_haseeb]

Hi try below for opposite

If i try this:   sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]-={'55302472','55868995'>}NUM_PAX_BKD_LB )

Regards

ASHFAQ

[anbu1984]

Try this

sum {$<[Consortium]={'xxxx'},[Agency]-={'55302472','55868995'>}NUM_PAX_BKD_LB )

[Anonymous]

Hi,

In set analysis, not equal is not <> but -=

HTH

Ravi N.

[PradeepReddy]

might be the syntax issue.. try this...

sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]<>{'55302472','55868995'}>}NUM_PAX_BKD_LB )

[#6]

It doesn't work:

Neither <> and nor -=

[ashfaq_haseeb]

Hi

Can you post your sample app.

Regards

ASHFAQ

[PradeepReddy]

try this..

sum({$<Weeks=,[Consortium]={'xxxx'},[Agency]={'*'}-{'55302472','55868995'}>}NUM_PAX_BKD_LB )

[sasikanth · Accepted solution]

HI Try some thing like this,

sum {$<[Consortium]={'xxxx'},[Agency]={*}- {'55302472','55868995'>}NUM_PAX_BKD_LB )

[#10]

Thnaks to all!