Formatting empty value cell in pivots

Arya · April 7, 2022, 8:31am

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%.

Bchadha · April 15, 2022, 12:08am

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

thomask · April 15, 2022, 11:12am

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

divey · September 8, 2022, 2:07pm

Hello,

Are there any updates on when this feature may be released?

ashish · March 31, 2023, 4:19am

Hello, I am still not able to replace blank with 0 using coalesce. Can you let us know if the feature is coming soon to handle blank with 0 or user to select and add values?

cbarnicle · April 13, 2023, 2:04pm

Hi - are there any updates on when this feature will make it to production?

Hassain · April 20, 2023, 11:44am

Hey @Bchadha,

Do we have any update on the feature ?

Biswajit_1993 · April 20, 2023, 12:20pm

Hello, @Arya Could you please retest using the same formula that @thomask shared?
Because whenever there is a null value, I always use the same formula.

PFB the snaps from my analysis.

Thanks & Regards
Biswajit Dash

Arya · July 26, 2023, 9:50am

Thank you @thomask . I have been using your solution to get around the problem.