If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Unexpected results on JOIN

Started by webartus, 28 Aug 2009 12:34:57 PM

Previous topic - Next topic

webartus

I am struggling to get Cognos to work the way I want it to. Here is my info:

ID
NAME
PRIZE = '2' AND [PRIZE_AMOUNT] is not null and [PRIZE_AMOUNT] > 0
PRIZE <> '5'
PRIZE_AMOUNT
FIELD_81 is not null
NOTIFICATION <> 'CURRENT'

Each customer can have multiple notifications. If the customer has received 'CURRENT' notification, they should be excluded from the list even if they have other notifications. If the customer has received PRIZE = '5' then they should be excluded from the list even if they have PRIZE='2' or any other PRIZE.

I have tried several approaches but cannot get the result that I am looking for. Any help/suggestions you brilliant folks can offer would be much appreciated.