Hello.
I’ve been trying to create this label for a few tables. The reasoning behind this would be to check if there are value in the “related” columns of the main table and, if positive, return a specific value.
Here it is:
The problem is that I get something like “null, null, Moldagem” as a result. I’d like to clear the resulting list from null or blank values.
Ive alreay tried subtracting a list from it, but it didn’t work. If I change “null” to “” in the expression, it’s all the same. Also tried Trimming, but to no avail.
This is an example of the values I get:
The whole reason for this is to make everything more readable.
Thanks in advance for any help!
What happens if you include the comma as part of the true case string and use an empty string “” instead of null.
1 Like
One easier option you may want to give a try is
(Your entire current expression you have shared in the screenshot above) - LIST(“null”)
I’ve tried doing that, but to no avail. It’s the same result… I’ve tried -LIST(null), -LIST(“null”), tried changing “null” to a word and then -LIST(“word”)… nothing at all worked 
I did both -LIST(null) and -LIST (“null”), and it didn’t work.. no clue why
Alright… To anyone going through this, I got it:
When I did LIST(CONCATENATE) - list(null), what happens is I’m creating a list where THE FIRST item is the concatenation (that was presented in a list form). Not so obviously (at least to me), when subtracting the null value, it was comparing the whole list that was inside the first item of the list with null. It was never going to work.
I have instead created a LIST on another virtual column, subtracting the NULL (it worked!), and then calling it back to the CONCATENATE. Here’s how it looks:
ggs
Thank you for the update. Good to know that it worked and also suggestion of using LIST(“null”) played a role in final solution.
Since one’s exact configuration sometimes is not known based on shared information, a tweak can be required at times to the suggestion.
