Calculating Discounts Part 2

I solved the problem in my Calculating Discounts post. Here is how it is done.

Variables
  ItemPrice = 50.00
  Discount  = 14.49%

Calculate Discount Value (DisValue)
  DisValue  = ItemPrice * (Discount/100)
  DisValue  = 50.00 * (14.49/100)
  DisValue  = 50.00 * 0.1449
  DisValue  = 7.245

Calculate NewPrice
  NewPrice  = ItemPrice - DisValue
  NewPrice  = 50.00 - 7.245
  NewPrice  = 42.755

Round Down Values
  NewPrice  = 42.75
  DisValue  =  7.24
  PriceDown = 49.99

Calculate CheckTotal
 CheckTotal = NewPrice + DisValue 
 CheckTotal = 42.75 + 7.24
 CheckTotal = 49.99

Calculate Missing Value
  MissValue = ItemPrice - CheckTotal 
  MissValue = 50.00 - CheckTotal 
  MissValue = 0.01

Add Missing Discount
  DisValue  = DisValue + MissValue 
  DisValue  = 7.25

Now the both the new price and the discount value will add up to the original price.

Calculating Discounts

Today we found an interesting bug in the software when discounts are applied to the transaction.

Here is an example.

Variables
  ItemPrice = 50.00
  Discount  = 14.49%

Calculate Discount Value (DisValue)
  DisValue  = ItemPrice * (Discount/100)
  DisValue  = 50.00 * (14.49/100)
  DisValue  = 50.00 * 0.1449
  DisValue  = 7.245

Calculate NewPrice
  NewPrice  = ItemPrice - DisValue
  NewPrice  = 50.00 - 7.245
  NewPrice  = 42.755

At this point we need to round the values, becuase prices have two decimal places. There are two options, we can either round the values up or down.

Round Up Values
  NewPrice = 42.76
  DisValue =  7.25
  Total    = 50.01 (1p over)

Round Down Values
  NewPrice = 42.75
  DisValue =  7.24
  Total    = 49.99 (1p under)

As you can see, when we add up the rounded totals, they do not match the original item price. So we need find a way to solve this problem.