Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe something like :
if ( not len( [YourField] > 0 , red())
Or: If(IsNull(Field_Name), ColorFunction())
I have used IsNull(Field_Name)
It works only if no filters applied.
=if(isnull([Клиент CRM]), rgb(225, 45, 45))
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())
Ooops!! Thanks RubenMarin for mending my typo, them brackets can be slippery blighters.
See project attached.
You can select someting in field Curr.
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.
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.