Conditional Formatting on null values doesn't work — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Conditional Formatting on null values doesn't work

Received Response
32
Views
3
Comments
User294199
User294199 Rank 3 - Community Apprentice

Hi,

i've a problem about conditional formatting on a pivot table:

I've following pivot table:

pastedImage_0.png

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