set analysis

[mario-sarkis]

hey all ,

i have a field for example

ID

001

002

003

004

005

006

how chan i write in the set analysis     sum(ID<> 001 and ID <>002,amount)

Thank you,

[PrashantSangle]

Hi,

Sum({<ID-={'001','002'}>}Amount)

or

Sum(if( not wildmatch(ID,001,002),Amount))

Regards

[MK_QSL]

SUM({<ID = {'*'}-{'001','002'}>}amount)

[#4]

Hi,

Try:

1--->Sum({<ID-={'001','002'}>}Amount)

2--->Sum({<ID={'<>001'},ID={'<>002'}>}Amount)

Regards,

Jemimah

[Anonymous]

sum({$<ID =E({<ID ={001,002}>})>}Amount)

[#6]

Hi Mario,

Try like this:

Sum({<ID = {''001','002'} > } Amount )

It's simple :

Sum ---------------------------------------------> Expression

{< Dim = { unique record} >} -    ----> Set

your req: Amount

Ramya.