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

Question on Advanced Conditional Formatting

Started by movieposters, 09 Apr 2024 08:29:18 AM

Previous topic - Next topic

movieposters

Hi, can't seem to tackle this conditional formatting issue.

I have multiple employee rows in a final query containing one summary row and multiple detail rows per each employee. 

The summary (rolled up) row is identified by having a running count field valued at 0, the detail fields starts at 1 and goes up to the last record for that employee. 

Looks like this:

Employee A    (key 0)      25.00
Employee A    (key 1)            10.00
Employee A    (key 2)              4.00
Employee A    (key 3)              8.00
Employee A    (key 4)              3.00

For employee A, only want summary line (keyed with a 0) to be bold.

I tried using advanced formatting, it brings up an area where you need expression.  I was hoping for something that looks like a filter so I can simply say (key = 0) then bold the amount. 

What am I missing!?  Any help...greatly appreciated - This is an example of what it would look like:  !


MFGF

Quote from: movieposters on 09 Apr 2024 08:29:18 AMHi, can't seem to tackle this conditional formatting issue.

I have multiple employee rows in a final query containing one summary row and multiple detail rows per each employee.   

The summary (rolled up) row is identified by having a running count field valued at 0, the detail fields starts at 1 and goes up to the last record for that employee. 
 
Looks like this:

Employee A    (key 0)      25.00
Employee A     (key 1)             10.00
Employee A     (key 2)              4.00
Employee A     (key 3)              8.00
Employee A     (key 4)              3.00

For employee A, only want summary line (keyed with a 0) to be bold.

I tried using advanced formatting, it brings up an area where you need expression.  I was hoping for something that looks like a filter so I can simply say (key = 0) then bold the amount. 

What am I missing!?  Any help...greatly appreciated - This is an example of what it would look like:  You cannot view this attachment.!



Hi,

You're going to need an expression that evaluates to True or False, so in that respect it works in a very similar way to a filter expression. If you want to be able to use the value of the [Key] item in the expression, and if the [Key] item isn't included as an item displayed in the List (but exists in the query), you will need to add the Key item as a property of the list. To do this:
- Select the entire list object (click on the 3 dots in the top left corner of the List)
- In the Properties pane, locate the Properties property, and click on the Ellipsis to edit it
- Add a check next to the Key item, and click OK.

Cheers!

MF.
Meep!

movieposters

Quote from: MFGF on 09 Apr 2024 10:18:26 AMHi,

You're going to need an expression that evaluates to True or False, so in that respect it works in a very similar way to a filter expression. If you want to be able to use the value of the [Key] item in the expression, and if the [Key] item isn't included as an item displayed in the List (but exists in the query), you will need to add the Key item as a property of the list. To do this:
- Select the entire list object (click on the 3 dots in the top left corner of the List)
- In the Properties pane, locate the Properties property, and click on the Ellipsis to edit it
- Add a check next to the Key item, and click OK.

Cheers!

MF.

Okay...wow! - this is so cool : ) Added the non-listed field (key) through the properties 'properties'.   This in turn showed under existing conditional formatting (no need to use advanced).  Changed the selection from 'String' to 'Numerical'.  Then set a value of 0, then set a condition if 0, then bold.   

SO.GREAT.! THANK.YOU.!

MFGF

Quote from: movieposters on 09 Apr 2024 02:01:28 PMOkay...wow! - this is so cool : ) Added the non-listed field (key) through the properties 'properties'.   This in turn showed under existing conditional formatting (no need to use advanced).  Changed the selection from 'String' to 'Numerical'.  Then set a value of 0, then set a condition if 0, then bold.   

SO.GREAT.! THANK.YOU.!


Great! Glad it worked for you!

Cheers!

MF.
Meep!