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

Avoid duplicates, display minimum value

Started by que1983, 30 Mar 2016 11:25:12 AM

Previous topic - Next topic

que1983

Attached is the query schema for a report.  Pend Details and Pipeline Details are linked to Report query1
Cardinality   1..n
Operator      =
Cardinality   1.1

When I add a field called pend_desc my detail including totals doubles.  This is because one record can have multiple pend_decr associated with it.  When I added pend_desc I changed the properties as follows:
Aggregate:  NONE
Rollup:    Minimum
Detail:    No

How can I capture only the first instance of the field so I can avoid the duplicates.

HalfBloodPrince

you can try something like maximum(pend_decr for pen_id).