Loading

Some of the values not populating in a Table view even though data is expected to be displayed in those cells

게시 일자: Jun 16, 2026
상세 설명

Check the underlying data for that cell by clicking on it and see if one of the columns in the calculation has Null values 

In Tableau, the result of Null + a value = Null  and 0 + a value = Value

 

솔루션

Use the ZN function to add the Zero If Null "ZN" to the calculation and that way Null+ a value will return a value and not Null in the cell.
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_number.htm#zn

For Example 



If a cell is intended to show the effect of a calculation where every value in Field 1 is Null and Field 2 contains real values, the following calculation will return Null values.

SUM([Field 1]) + Sum([Field 2])

But if ZN (Zero if null) is added to that calculation, the cells will then display values of Field 2 

SUM(ZN([Field 1])) + Sum(ZN( [Field 2])) 

 

Knowledge 기사 번호

004980250

 
로드 중
Salesforce Help | Article