This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Hi @hash_89, convert the numerical columns into Double datatype and then do the computation. The final result comes out to be 100 in this case, after which you can convert it to fixed decimal with two decimal places if that's how you want your output to look like.
I have attached a modified version of your file for your reference.
The differences are due to rounding - I noticed you're using a fixed decimal with two decimal places as your data type and also rounding to two decimal places in your formula. Try expanding the number of decimal places. I expanded it to a fixed decimal of 26 digits with 10 decimal places and am seeing a total of 100%. See attached.
The difference between the different types of numeric formats is the level of precision. This can affect your overall outcome.
as @AbhilashR and @echuong1 already explained, the difference is caused by rounding. The only solution I can imagine is to add a "correction" to the rows having the maximal difference between rounded and unrounded percentages. In your sample, there are 3 rows with a rounding difference of approx. 0.005 %, I would adjust these rows by 0.01%. I've attached a sample workflow.