Calculate difference between previous and current amount
How to add a column for calculating the difference between yesterdays closing amount and todays opening amount
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):
Code Snippet (add any code snippets that support your topic, if applicable):