Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello dear developers,
I am trying an easy formula but somehow it is not working out for me.
I am setting up a table, and it is showing a dimension, where many values are null values, so an ugly "-" is displayed. Instead of that, I would like to have a legend.
This is the formula I am using:
= if(IsNull(Vendor), 'No vendor', Vendor)
any help is appreciated! 😄
thanks
The formula works, although I would use this one instead so you can select filters from the table:
=Aggr(If(IsNull(Vendor), 'No vendor', Vendor), Vendor)
Why it is not working for you I don't know. Here are a few things you can try:
NullAsValue Vendor;
Set NullValue = No vendor;
// Load the final field here
NullAsNull;
Hello, I think this might work
Coalesce(Vendor,'No Vendor')
No, it did not change anything , still showing the "-" 😞
The formula works, although I would use this one instead so you can select filters from the table:
=Aggr(If(IsNull(Vendor), 'No vendor', Vendor), Vendor)
Why it is not working for you I don't know. Here are a few things you can try:
NullAsValue Vendor;
Set NullValue = No vendor;
// Load the final field here
NullAsNull;
@Nemo1 Null is different from a blank, and I prefer handling this differentiation at the backend.
If(Len(Trim(Vendor)), Vendor, 'No Vendor') as Vendor
Try this
If(Len(Trim(Vendor))=0, 'No Vendor', 'Vendor')
It did work, thanks!!