The truncation and rounding function are just some toolings.
When processing a lot of numbers the real practical issue is caused by not understanding the effects precison losing some digits by accident.
For science where that difference doesn't matter, who cares. For accounting and bookkeeping (the common BI usage) really problematic as not being accepted by intended customers.

Any way to overcome those?