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: !
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: Conditional Formatting Example.png!
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.
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.!
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.