Row wise subtraction

[dmtauto72]

I have a table containing fields 

ID, Date, Amount, Payments

 say first row has

0001, 1-Feb-2024, 100000, 10000

in next row user will input only last field (Payments)

unique ID works well for ID field today() also works fine

what i want is 90000 in Amount field without user input

I tried with two tables, virtual column but I am stuck

Please help

[AleksiAlkio]

 So.. do you want to count it from the one row before like 100.000 - 10.000?

[dmtauto72]

Sorry for the late

yes, I want to subtract 10000 from 100000 and get 90000 in next row below and so on

Please help.

[AleksiAlkio]

You can read for example the Amount with something like..

LOOKUP(MAXROW("Table","Date",[Date]<[_THISROW].[Date]),Table,ID,Amount). So you need to read the Payments with the same way.

[dmtauto72]

Thanks for the help It worked for first row but not getting continued 

my expression is

LOOKUP(MAXROW("Table1","Loan Date",[Loan Date]=[_THISROW].[Loan Date]),Table1,Sr No,Loan Amount)
-
LOOKUP(MAXROW("Table1","Loan Date",[Loan Date]=[_THISROW].[Loan Date]),Table1,Sr No,Repayment)

Please help

thanks for the support 

[AleksiAlkio]

You need to use "<" insted of "=" as it was in the sample I proposed.