Hello

here is something you could try, do some format to the field

go to special values, and add 0, it may give you what you looking for

cheers

Hello Vadivelu,

Please find the solution for Null Replacement by Zero.

1. create formula for concern measure using below formula

   eg   ifnull(<measure value>,0)       -- here Red colour zero is replacement value when measure is null

2.  create table with total & subtotal.

3. cross reference/check purpose add - original measure value also in same table .

Null replaceby0 -- is acalculated column

Sales -- Original measure column.

summary : Not required to implement customized formula, hence tableau  has implemented that null replaced by 0.

Thanks

Palani

we can use the following ways to replace nulls

1) zn([sales])

2) if( isnull([Sales]), "Null", [Sales]))

3) As Ramu attached a screen shot

Best Regards

Laxman Kumar

Hello,

Do you have any update, please ?

It is very inconvenient for the client to have blank cell instead of 0 value.

Marcin

I have the same problem.  Has anyone found a solution to this?  The issue is when there is an "EMPTY" value (not null value) we need the data to have a 0 value.  In my case, I cannot format the field to show a 0 instead of blank because I actually need the VALUE to be 0.

I also have the same issue and I hope someone can help.

Hi Scott,

Use the below formula to show 0, when there is a null or for a blank record in the database. 

ZN(LOOKUP(SUM([value],0)))

If you still have problem,attach the workbook.

Regards

Swarup.

Hi Swarup.

I have tried this with no luck.  I am using the example workbook as a reference from this thread.

Re: Setting null values to zero

However, when I create that calculation and drag it over, it doesn't work.  I have noticed that it changes from calculating across the table to down the table.  I am not sure if that is affecting it or not.  Also, the difference between mine and the example is that i have sub-groups under the main group.

Unfortunately, I can't attach the workbook because it is large with proprietary data in it.  Here are some screenshots of what I am talking about.  Maybe that will help.

Hi Scott

Just small change in the formula you are referring workbook. Open in 9.3.

Replace the logic according to your requirements, let me know if you still have any issue.

That particular workbook is just an example I found.  I was trying to use what they did in mine.  I did go ahead and try that particular logic in mine but it still isn't working.

Hi Scott

Check with below formula.

ZN(LOOKUP(SUM(IFNULL([Number of Records],0)),0))