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!