Hi, Is there a way to fill the empty rows with zeros? It’s not null; the data simply doesn’t exist for that row in the dataset. [image] I’ve tried many calculaded fields, but didn’t work. My current calculated field is this: ifelse( isNull(sum(valorbaixaparcela)) OR sum(valorbaixaparcela) = 0, …

Hi @glopes , Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed. Thank you!

Fill Empity space with zero

Q&A

Deep March 19, 2025, 7:33am 2

Hello Guilherme,

Please see this old post if it helps -Replace blank/NULL values by 0

Cheers,
Deep

1 Like

Topic		Replies	Views
Formatting empty value cell in pivots Q&A formatting , feature-request , quick-sight , how-to	8	2291	July 26, 2023
How to show 0 instead of blank in pivot table where records does not exist Q&A formatting , feature-request , quick-sight , how-to	2	797	May 16, 2023
Filling missing value with 0 in pivot table Q&A developer , row-level-security , quick-sight	3	311	April 15, 2024
Replacing Numeric Column Blank Data With 0 Q&A quick-sight , calculations , how-to	3	1442	June 18, 2022
Include a default value to Pivot Table cellls Q&A quick-sight , how-to	10	579	June 2, 2023

Fill Empity space with zero

Related topics