Question

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

  • 24 July 2022
  • 2 replies
  • 21 views

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.

 

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


2 replies

Userlevel 7
Badge +1

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.

Userlevel 6
Badge

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

Reply