How to show the value 0 instead of "no_data"?

Question & Answer
, , ,
1

Hi,

I have a calculated field in a KPI and I would like to show the value 0 instead of showing “no_data” when the value is null. I tried to create a calculated field using nullif, ifelse and isnotnull, but it didn’t work.

Calculated Field:
tx = (quantity_ef / quantity_s) * 100

I tried to make some fields, but it doesn’t work.

Ifelse (tx = " " , 0, tx)

Nullif(tx, 0)

IsNotNull(tx)

How to do that it?

Thanks

July

2

@July
Hi,
Is it possible that your null is actually “null”?

1 Like
3

Hi @neelay

I guess sometimes it can be “none” or empty.

I would like to show “0” instead of “no_data”. Are there a way for that ?

Thanks

4

@July you have to account that in your custom field formula