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