Forum Discussion
My Percentage of total sales is not 100 - Why?
I'm new to this and have a similar issue. I summed my percentage columns and reached 100% in two of the three columns in my datasheet, however, the third is 3.26% over. I've checked my formulas, my formatting and my arithmetic. What could be my issue?
Metts518 : there could be several different causes. You give no indication of what kind of data you're dealing with, whether one of more of the columns involves some rounding to nearest whole digit or two decimal places or whatever. Rounding, which most of us think of as "rounding up" could be the cause of your issue. I just recently (in another thread in this forum) learned of what's called "Bankers' Rounding," a method to minimize what you may be experiencing.
Many, many thanks! I have never heard that term either. I'll look into it. I believe my issue was found in a simple sum error of all things. I'm grateful for your time in trying to help. I will provide more details in the future!