topic Re: Why is this easy formula not working for me? in App Development

Why is this easy formula not working for me?

Nemo1 — Fri, 15 Nov 2024 21:02:02 GMT

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

Re: Why is this easy formula not working for me?

Clement15 — Tue, 12 Mar 2024 08:21:20 GMT

Hello, I think this might work

Coalesce(Vendor,'No Vendor')

Re: Why is this easy formula not working for me?

Nemo1 — Tue, 12 Mar 2024 08:28:14 GMT

No, it did not change anything , still showing the "-" 😞

Re: Why is this easy formula not working for me?

LRuCelver — Tue, 12 Mar 2024 08:36:12 GMT

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:

Check whether the "-" is actually NULL or whether it is a string
Fill the NULL values in the script. There are several options:
- Use NullAsValue to replace the missing values (see code below)
- Use your expression in the script
- If vendors are linked to a fact table via an ID, add a new ID for missing vendors (e.g. -1) and concatenate a corresponding row to the vendor table.

NullAsValue Vendor; Set NullValue = No vendor; // Load the final field here NullAsNull;

Re: Why is this easy formula not working for me?

BrunPierre — Tue, 12 Mar 2024 08:52:39 GMT

@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

Re: Why is this easy formula not working for me?

Nagaraju_KCS — Tue, 12 Mar 2024 09:08:26 GMT

Try this

If(Len(Trim(Vendor))=0, 'No Vendor', 'Vendor')

Re: Why is this easy formula not working for me?

Nemo1 — Tue, 12 Mar 2024 09:11:04 GMT

It did work, thanks!!