Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the Missing Symbol setup to display the value "N/A" and I want to make the cell change color when this value is returned. Is the reason why it won't change the color of the cell when the value is "N/A" because it represents a field that has returned no data? I am able to change the cell color when a number is returned as a value. I have this setup in an Expression under the Background Color Expression.
thanks,
Ryan
Sure. Here's an example.
Great, thanks so much. My developer is working on implementing this!
Hi everyone,
Is there a way to colour missing cells? I see that this topic shows how to colour the null values which i was aware of. however, the data for mine is definitely missing and not 'null'. Is it possible to do this?
Thanks,
Furthermore,
In a pivot chart my subtotal is taking a colour value when i would like it to remain white. Any way around this?