The total has already been calculated, so it is wrong to use the total to calculate it. The correct total calculation formula is:
Please click to enter a picture description.
3. If the calculation does not involve decimals, it may be as you wish. If decimals are involved, the intermediate results cannot be used for secondary calculation, which will lead to an increase in error. Take another example of the community, and you will know it at a glance: