Calculate difference between previous and current amount

Summary:

How to add a column for calculating the difference between yesterdays closing amount and todays opening amount

Content (required):

We have built a simple OTBI report for showing the opening and closing bank account balances.

We want to add a column for calculating the difference between yesterdays closing balance and todays opening balance.

I have included a screenshot of the report and also an export where I have shown what we want to achieve.

Basically, (OPBD +0) Amount - (CLBD -1) Amount.

Version (include the version you are using, if applicable):

22C

Code Snippet (add any code snippets that support your topic, if applicable):