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

How to format a total based on conditional formatting

Started by DEL2026, 01 Nov 2010 08:15:30 AM

Previous topic - Next topic

DEL2026

I am trying to add a sum/total to my list report that counts values that are formatted in Green font.   

I have several queries to show specific values in green (conditional formatting) and would like to total only these "green" values.  I'd like the total to also show in green.  (Example:  My Conditional Expression is if([Query 1].[Format] = 'Yes') then 'Yes'   --The second 'Yes' being the value that turns the text to green.)

Suggestions on how to create the "green" total?  Thanks in advance.