Fill Empity space with zero

Question & Answer
, , , , ,
1

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
image706×437 38.8 KB

I’ve tried many calculaded fields, but didn’t work. My current calculated field is this:
ifelse(
isNull(sum(valorbaixaparcela)) OR sum(valorbaixaparcela) = 0,
0,
sum(valorbaixaparcela)
)

2

Hello Guilherme,

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

Cheers,
Deep

1 Like
3

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!

4

Hi,

I think you can use coalesce for this.

sum(coalesce(valorbaixaparcela,0))

5

Hey thomask,

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

6

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

7

I couldn’t find a solution!

8

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 solving your issue.

1 Like
9

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.

Thank you!

10

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!