A Table in my report is showing data from a dataset where some values are NULL. Using keychains I’d like to show something else as <N/A>. I’m trying with something like
val!=null?val:'--'
or using None instead of null but nothing seems to work.
Any suggestion is appreciated.
Thanks, regards
The first is that the false expression is
optional (it will default to null). The second is that RM will evaluate 'null' as false and non-null as true,
so you can provide null substitutions like this: @name? name : "(None provided)"@.
With changing the background color you might be able to run a getBackroundAt extension function get the value of the cell if it equals <N/A> or whatever your null value ends up being and change the background color based on that.