Forum Discussion

cosmasadesegha's avatar
cosmasadesegha
Frequent Visitor
5 years ago

Subtotal rounding issue

I am wondering why my subtotal is not rounding as expected. I expect to see $26,680.37 but was getting $26,680.35 as shown below. Kindly help    
Need Help
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

In most cases, the subtotal will show the sum of the actual underlying numbers, rounded to a certain number of decimal places, rather than the sum of the displayed numbers, which may be rounded.

 

If you expect your rounded subtotals to always be the sum of the rounded components then you are not going to have a good time in general since the requirement leads to showing inaccurate totals or inaccurate components.