Utilising another column when doing calculation (from same table)

Hey,   I've been trying to do this for ages now, and I either have missed something very simple or what I'm trying to do isn't plausible.   I'll try include as much detail as possible.   At pre...