Last Modified Date: 30 Jan 2020
- Tableau Desktop
- FIXED LOD expression that references 4 dimensions
- Boolean expression that compares a field against zero (0)
Option 1Use a calculation that preserves the precision of the field being compared against zero, but avoids comparing a decimal number against the integer zero, e.g.:
(INT (1000000* SUM([decimal number field])) = 0
Option 2Change the data type of the numerical field being compared in the Boolean expression to Number (whole).
CauseThe LOD expression references a Boolean field which compares a field with decimal number type against the integer zero. Comparing floating-point numbers can cause issues in equality tests. For more information, see this article about how comparing floating-point numbers can cause unexpected results.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials