SQL Server – calculated column

I need to create a column in a view which is derived as below.

The calculated column is derived from Amount column where a row value is derived by subtracting from previous row value of Amount, and every 1st contract that starts will have no value as it’s the first row of that contract.

Can someone please suggest what option I have to achieve this?

Any suggestions are welcome.

>Solution :

This is a way to do it using window function LAG() to get the previous value :

select *, Amount - lag(Amount) over (partition by Contract order by DateValue) as [Calculated Column]
from mytable

Demo here