Formatting empty value cell in pivots

Hello Team. I am trying to format a pivot table value field well which currently shows empty for some cells and want to replace these with a custom value. Please refer to the image below. The third row currently shows empty and ideally want to replace that with 0%.

image

Hi Arya,
We are aware of this missing feature and are tracking this in our backlog.

Hi,
you can solve this with a calculated field and use coalesce(value,0).

1 Like