Last Modified Date: 04 Jun 2018
ResolutionFor NULL data, wrap the field in ZN(). For example, the following calculation:
AVG( [Sales] )
AVG( ZN( [Sales] ))
For missing data it may not always be possible to replace missing values with zeros. Depending on how the view is built it may be possible to achieve the desired results with table calculations. For directions, please see Populate Empty Cells in a Text Table with Zeroes or Existing Data
Aggregations ignore NULL values. The function ZN() converts NULL values into zeros in order to be included in the average.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials