30,997
edits
| Line 30: | Line 30: | ||
Also if you decide to round up or down instead of "to the nearest", you will have same problem (for example with a rounding down, try with a quantity of 2 on line 2 and you will have same differences between method 1 and 2). Difference will just appears with different data but will still occurs. | Also if you decide to round up or down instead of "to the nearest", you will have same problem (for example with a rounding down, try with a quantity of 2 on line 2 and you will have same differences between method 1 and 2). Difference will just appears with different data but will still occurs. | ||
Second thing we can note is that if we use method 2, we must not show the column I, otherwise to total you will show on your invoice (2.73) will not be same that total you get summing total | Second thing we can note is that if we use method 2, we must not show the column I, otherwise to total you will show on your invoice (2.73) will not be same that total you get summing total of each line (1.36+1.36=2.72). Showing column H might be better but total will still differs because total is rounded and result of summing column H lines. | ||
'''So what to do ?''' | '''So what to do ?''' | ||