Yeah, thanks, I have been in the business of data quality for a large financial application running in several different countries for long enough, I know very well how to make things look right, rounding first and then summing.

But that's precisely my point. Making the thing look right this way is likely to make the sum less accurate (especially when they insist at the same time on using rounding methods that will not even out rounding errors in a large sum and will tend on average to make the sum slightly larger than reality -- but that's a different story).

And that's exactly what I was saying about people in finance, accounting and audit departments: they want things to "look right" much more than they want the calculation to be accurate.

I can perfectly understand their concerns and I have no problem with these choices. It even happened at least two or three times that I was the one who suggested them the solution to round first and then sum, as a way to get exactly the look they wanted, but warning them at the same time that it would make the calculations less accurate. In at least one occasion, I even prepared a detailed spreadsheet showing what happened depending on where the rounding was made in a number of scenarios and pointing out that it would look right but be slightly inaccurate in a relatively significant percentage of the invoices (usually just one or two cents above the real amount). They were really unimpressed about lesser accuracy to put it mildly (in fact they didn't give a sh*t about it) and they jumped on the solution that looked right.

So, again, I am not criticizing their choices, but, contrary to what has been said by another monk before, these people should hardly be given as an example of rigor and accuracy.


In reply to Re^13: Reasons for Using Perl 6 by Laurent_R
in thread Reasons for Using Perl 6 by aartist

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.