go ahead... be a heretic PerlMonks

### Re^2: How to calculate the sum of columns to be equal to 100?

by Laurent_R (Abbot)
 on Aug 15, 2013 at 13:35 UTC ( #1049588=note: print w/replies, xml ) Need Help??

Yes, fudging the data is one solution.

The company for which I work as an independent consultant spent a few years back several hundred thousand euros trying to get their invoices "look right" (about 20 million invoices per month). After a lot of thinking, simulations on Excel, consultations with accountants, auditors and tax advisers, prototyping, etc., it was finally decided that all the invoice individual lines and subtotals would have 5 decimal digits, and only the invoice total (and VAT) would be rounded to the nearest cent. There may still be some rounding differences, but, at least, nobody really cares about a difference of 0.00001 euro.

• Comment on Re^2: How to calculate the sum of columns to be equal to 100?

Replies are listed 'Best First'.
Re^3: How to calculate the sum of columns to be equal to 100?
by choroba (Chancellor) on Aug 15, 2013 at 13:46 UTC
I have also seen invoices in which the last line before the invoice total is a "rounding compensation", something like -0.01.
لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ

Create A New User
Node Status?
node history
Node Type: note [id://1049588]
help
Chatterbox?
 [stevieb]: I just don't feel like going hardcore on anything today, so I thought I'd *use* my software instead of just write it [beech]: let the surprises begin :D

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (5)
As of 2017-07-21 23:29 GMT
Sections?
Information?
Find Nodes?
Leftovers?
Voting Booth?
I came, I saw, I ...

Results (336 votes). Check out past polls.