Last Modified Date: 08 Jul 2022
Environment
- Tableau Desktop
- FIXED LOD expression that references 4 dimensions
- Boolean expression that compares a field against zero (0)
Resolution
Option 1
Use 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 2
Change the data type of the numerical field being compared in the Boolean expression to Number (whole).Cause
The 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
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials