There is one thing that is useful to keep in mind when creating views : the less work the view design has to do, the faster it will display and update.
In other words, if you have results to display in a view, and those results are rather process-intensive, it is better to put a hidden field on the form and do the calculations there, then just display the field value (the result) in the view.
That being said, view column formulas do not have any means of taking into account results from another column. There had been talk about such functionality for R6, but in the end that got removed, or was never brought to beta. You can play will column values in LScript, but you do not have access to that in column formulas.
So, if you must do the calculation in the view, you will have to repeat the formula for the first column in the second one, and work from there.