KNOWLEDGE BASE

The Calculation Result Of Zn() May Have Changed After Upgrading To 2020.2 Or Further Version


Published: 30 Jan 2021
Last Modified Date: 01 Feb 2021

Issue

For some specific nested calculations using ZN() and IF function, the result changed after upgrade Tableau Desktop or Tableau Server to 2020.2 or further version.

Example:
In version after 2020.2, when ZN([IF]) returns 0, 
ZN([IF]) = 0 returns "false"
ZN([IF]) > 0 returns "true".

In version before 2020.1, when ZN([IF]) returns 0, 
ZN([IF]) = 0 returns "true"
ZN([IF]) > 0 returns "false".

Environment

  • Tableau Server 2020.2 and later
  • Tableau Desktop 2020.2. and later

Resolution

As a workaround, adding INT() out of the ZN() function.

Example:
Change ZN([IF]) to INT(ZN([IF]))

Cause

The issue is under investigation by development team.
Did this article resolve the issue?