• I want my points back.  This question was as badly conceived as the other coffee card question a couple weeks ago.  The only reasonable answer is to use FLOOR(ABS(n)), and then remember which item (charge/deposit) should be considered negative.

    And if you want to keep track of the balance on your coffee card, wouldn't you subtract purchases and add deposits?  So if the balance is positive you can afford more coffee.