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!

Hi Deep, This only solve the visual part of the problem. In my case I need to have the sum of the rows and if a do the concat as shown in the post you sent, the sum won’t work!

Hi, I think you can use coalesce for this. sum(coalesce(valorbaixaparcela,0))

Hey thomask, I’ve tried to use coalesce but didn’t work too!

Hi @glopes , Checking in here as it’s been awhile since last communication on this thread; are you still working on this case or were you able to find a work around in the time since? If we do not hear back within the next 3 business days, I’ll close out this topic. Thank you

Hi @glopes , I’m wondering if this has something to do with the fact that you’re using a pivot table and separating by month; you may need to include month in your calculated field aggregation for it to assume where the 0 should replace a null or blank field. Let me know if that could help in solvi…

Hi @glopes , Checking in here again as we have not heard back in a while, if none of the options suggested above worked for your case, you may want to create a support ticket with AWS to get more direct assistance. If we do not hear back within the next 3 business days, I’ll close out this topic. T…

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

Topic		Replies	Views
Formatting empty value cell in pivots Q&A formatting , feature-request , quick-sight	8	2397	July 26, 2023
Filling missing value with 0 in pivot table Q&A developer , row-level-security , quick-sight	3	359	April 15, 2024
How to show 0 instead of blank in pivot table where records does not exist Q&A formatting , feature-request , quick-sight	1	844	May 16, 2023
Empty cells in pivot table not showing as 0 when coalesce is added Q&A quick-sight	9	529	August 26, 2025
How to show Zeros in the pivot table where there is no data for Specific Months Q&A quick-sight , calculations , pivot-table , Business-Intelligence-Engineer	10	410	August 1, 2024

Fill Empity space with zero

Related topics