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.
I tried your idea but it did not work. Value is still empty.
Sorry. I did not get your complete solution but if you are asking me to use a calculated field wherein check for null and replace the [Number of Records] column, I did try the same like following but it's not working either.
ZN(Lookup(Sum([Number of Records]),0))
Did I not make it clear or something ? I thought it would be a simple solution but could not get it to work and more surprisingly no solutions from the group. Do I need to add more info from my part ?
we can use the following ways to replace nulls
2) if( isnull([Sales]), "Null", [Sales]))
3) As Ramu attached a screen shot
Do you have any update, please ?
It is very inconvenient for the client to have blank cell instead of 0 value.
Use the below formula to show 0, when there is a null or for a blank record in the database.
If you still have problem,attach the workbook.
I have tried this with no luck. I am using the example workbook as a reference from this thread.
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.
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.
Zero Nulls Eg_RL.twbx 368.4 KB