[APEXMALHAR-665] Support Monetary Calculations in Operators

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: algorithms
• Assignee: Amol Kekre
• Reporter: David Yan
• Created: 20/Jan/14 19:08
• Updated: 20/Jan/14 19:09

Description

Currently Average operator has calculations with double, which in general may not be well suited for monetary operations (this can lead to incorrect results).
sums += tuple.doubleValue();

Reason:
"The float and double types are particularly ill-suited for monetary calculations because it is impossible to represent 0.1 (or any other negative power of ten) as a float or double exactly."

Solution:
"Use BigDecimal, int, or long for monetary calculations."

Reference:
Bloch, Joshua (2008-05-08). Effective Java (2nd Edition) (Java Series) (p. 218). Pearson Education. Kindle Edition.