Session result calculation based (including previous result)

I have a table with a long list of assessment results, both the test and review, and based on that I need to calculate the New_Result.   What I need to do is determine the New_Result based on the p...