How to display nothing (blank soace) in the place of Null values (‘Phi’ symbol)

NIX
Explorer

I want to display Null values as empty cell values, how can I acheive that.
I neither want a Phi symbol nor 0 displayed in the table as shown in the picture below.

36bf2618-e651-487b-8e89-b96903a39a34.png

As in the picture displayed above, it should be just a blank space, instead of NULL. The value above are genererated using a pivot.

0 2 3,053
2 REPLIES 2

Dawid
Participant V

You have three choices:

  1. NULL
  2. 0
  3. empty string

I believe your “blank space” is an empty string but your value is numerical, hence it would render the data points incompatible.

If it’s crucial for you to do so, you would need to convert your numerical value to string with Table Calculation coalesce(to_string(<field>), “”) but that means you would lose your dollar formatting.

IanT
Participant V

Maybe liquid in html to check when it’s null then html empty string.

Top Labels in this Space
Top Solution Authors