Problem or error: Due to limitations of the data types used in
Campaign , precision loss can occur in a number of circumstances. For example, when numbers greater than 15-digits are used,
Campaign approximates these values. Also, when adding non-integer values, precision is lost (for example,
95.1 + 4.9 may not equal exactly
100).
Solution: Possible workarounds: When working with non-integer values, if you can make them integers with fewer than 15-digits, there will be no loss of precision. For example, multiply the values in the previous example by 10, add a small delta such as .3, then use the
FLOOR() macro to change the value to an integer. This would correctly compare
951 + 49 = 1000 as
TRUE.