How to highlight NULL-valued cells in dimension

[#1]

Hello

How can I highlight NULL-valued cells in dimension of Straight table?

For example how can I process dimension cell value in background color expression?

Thank you!

[Anonymous]

Maybe something like :

     if ( not len( [YourField] > 0 , red())

[rubenmarin]

Or: If(IsNull(Field_Name), ColorFunction())

[#4]

I have used IsNull(Field_Name)

It works only if no filters applied.

=if(isnull([Клиент CRM]), rgb(225, 45, 45))

[rubenmarin]

I have something similar in one app and is working, maybe in some conditions it stops working, mine was a simple straight table.

Can you upload a sample? I'm curious to know when it stops working.

Anyway you can try the solution proposed by Bill, just close the Len():

if ( not len( [YourField]) > 0 , red())

[Anonymous]

Ooops!! Thanks RubenMarin for mending my typo, them brackets can be slippery blighters.

[#7]

See project attached.

You can select someting in field Curr.

[Anonymous]

You have got Set Analysis in your 2 expressions to force them to override the manual selections for Curr to select r & u respectively.  So your manual selections will never work properly and things will generally be messed up

Try using a Pivot Table adding Curr as a dimension and with just one expression to sum Val, Always Fully Expanded with the Curr Dimension dragged from the left to the top.

Hard to explain in writing.............. see attached.

[#9]

Thank you for your work!

It was helpful.

But the question "how can I process dimension cell value in background color expression?" still not answered.