Product of Percentage Multiplication Incorrect?

Options
cbrookes
cbrookes Member, ALL USERS, Community Member Posts: 5 Contributor

Hi All, 

 

I ran into a strange issue while troubleshooting some UAT feedback. The model is multiplying 35% by 3 and outputting 104.999999999999998%. 

 

It was easy to solve this by using the ROUND function, but I want to understand why this is happening. 

 

Below is a drill down of the calculation:

cbrookes_0-1644521186464.png

Tagged: