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

equal values in list column body cells

Started by johangel, 16 Jan 2009 03:40:48 AM

Previous topic - Next topic

johangel

When all the values (not numeric) in list column body cells are equal I have to hide them by using conditional formatting.
With condition I have to use for this?
In BO it was simply "when max(body cell) = min(body cell) then 'equal' else 'not equal'
Sincerely,
J.

jshanks

What if you perform a COUNT DISTINCT calculation on the column and then set a BOOLEAN render variable on the "List Column" object?  The render variable would be something like below:

COUNT( DISTINCT [column] ) > 1

When this condition evaluates to TRUE, the column will be rendered in the report output.  If it evaluates to FALSE, the column will not be rendered.

johangel