Forum Discussion
Advanced Rounding Question
I am creating a timesheet calculator. An employee will enter a number (hours) and the number will be split up by a number of selected timecodes with different percentages. The number of timecodes wil...
Okay I've given up on the previous method. I have a different issue now. When I enter a number, if I don't round the numbers, the values in the columns don't equal up to the correct total. See column on the right below. Please note that I specifically need 0.1 accuracy for this visual.
If I round the numbers to 0.1 accuracy the values match the total but the total doesn't match up with the number entered. (left column) I understand that this is basic limitation of rounding but is there a way to get both the values and the totals to match with 0.1 accuracy? If not, is there a way to add or subtract the difference to or from the rows to get the totals and values to match the amount entered?