^I think you could just make a formula for 5th column that is ((Sum of Columns 1 and 2) - Amount for the Year))

It allows me to have TWO variables only AND it must not be a Formula field.