In highlight table I don't want blank or white if the data is Null it should get replace with zero or "-".Or If it remained blank then there should be same color to be present in it. I tried by creating calculated field with 'zn' function i.e zn([Quantity]), but still it remains as it is.
4 réponses
Ooook,
I found it!
So, what you get, it's not technically a NULL value, but a missing one.
So, you should transform your SALES in:
LOOKUP(sum([Sales]),0)
then you can right click
,
choose the measure
and work with Special Values.
Does it work for you?
Hope it can help!