Categories
- All Categories
- 14 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.6K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Conditional Formatting on null values doesn't work

Hi,
i've a problem about conditional formatting on a pivot table:
I've following pivot table:
The second and the third row of Quantità Lorda are blank because there aren't values in DB (All dimensions are in full outer join).
On the column i've applied Conditional Formatting : WHEN Color = 'AZZURRO' Background green.
The editor fills only first cell, the only one with a value in DB, conditional formatting doesn't work for the whole column. How can I do ?
I've tried to apply ifnull function to Quantità Lorda column:
IFNULL(Quantità Lorda, 0), but as you can see blank values aren't replaced by 0. Maybe the real value isn't NULL?
I'm so frustrated.
Regards
Giancarlo
Answers
-
-
Hi,
i use:
Oracle Business Intelligence 11.1.1.7.140715
OS: Windows 7 Professional 64 bit
Browser: Firefox 73.0.1 (64 bit)
Regards
0 -
https://dimensionality.ch/2017/05/06/installing-oracle-bi-on-windows-7-8-10/
Desktop operating systems are not, have not been and will not be supported platforms for OBIEE. Especially not Windows 7 which isn't even supported by Microsoft itself anymore.
Also: You're not stating what EXACTLY the rules are which you've implemented. You need to be more specific.Conditional formatting on NULLS is basic functionality.0