how to calculate opening account

[#1]

Hello,

Find attached excel file. how do i calculate opening account from my credit and debit account + previous day of opening account.

Rgds

[Gysbert_Wassenaar · Accepted solution]

Like this?

Data:
LOAD date(Date,'MMM-YY') as Date,
    [Opening account],
    Debit,
    Credit,
    rangesum(peek([Opening balance]),previous(Debit),-previous(Credit)) as  [Opening balance]
FROM [opening account.xlsx]
(ooxml, embedded labels, table is Sheet1);