Sum a set not equal to

[tinkerz1]

Hi,

I am trying to use the following example to sum everything when in a set [ABC] that does no contain *Threshold*

Re: Not equal to in set analysis

Any help please...my 3 variants are not working, the last two are from the above example

Sum({[OHRL]<[ABC]<>{'*Threshold*'}, Group=OHRL::Group>}Data)

not equal too

Sum({[OHRL]<[ABC]-={'*Threshold*'}, Group=OHRL::Group>}Data)

not equal to v2
Sum({[OHRL]<[ABC]={"=[ABC] <>'*Threshold*'"}, Group=OHRL::Group>}Data)

[swuehl]

First variant is not expected to work.

Variants 2 should / could work. If you think it doesn't, please post some sample data, your expected results and the context you are using these expressions. Best by uploading a small sample QVW.

Variant 3 needs a modification to allow the wildcard usage:

Sum({[OHRL]<[ABC]={"= not ([ABC]  like '*Threshold*') "}, Group=OHRL::Group>}Data)

[sunny_talwar]

Try this may be:

=Sum({[OHRL]<[ABC] = e({<[ABC] = {'*Threshold*'}>}), Group=OHRL::Group>} Data)

[pratap6699]

use implicit function in set expression E()

=Sum({[OHRL]<[ABC] = E({<[ABC] = {'*Threshold*'}>}), Group=OHRL::Group>} Data)

[ramoncova06]

here goes another option

Sum({[OHRL]<[ABC]={"=index([ABC],'Threshold') < 1 "}, Group=OHRL::Group>}Data)