Why does 0.1 and 0.2 = 0.30000000000000004?
Both Excel and Google Sheets return FALSE for this expression:<p><pre><code>    2.03 - 2 - 0.03 = 0
</code></pre>
The vast majority of data transformation and BI tools (Power BI, PowerQuery, Tableau, etc.) return FALSE for this expression:<p><pre><code>    0.1 + 0.2 = 0.3
</code></pre>
That&#x27;s because they use floats instead of decimals and that introduces subtle errors in data. These errors usually never get noticed because everyone doesn&#x27;t expect errors in basic math. It&#x27;s a mystery to me why most commercial software intended for business and financial calculations don&#x27;t use fixed point decimals. My post about this: <a href="https:&#x2F;&#x2F;www.linkedin.com&#x2F;feed&#x2F;update&#x2F;urn:li:activity:7028101503949168641&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.linkedin.com&#x2F;feed&#x2F;update&#x2F;urn:li:activity:7028101...</a><p>PS. If you design software that works with money amounts, always use fixed point decimals. Don&#x27;t use floats, it&#x27;s just wrong!