You have a few options to consider:
Modify the dimension statement report: You can make changes to the existing report by adding a new column for the Net balance calculation. This would involve modifying the report's design and adding the necessary formula or expression to calculate the difference between the Debit and Credit columns.
Create a financial report: Another approach is to create a new financial report specifically for this purpose. This report can be designed to include the desired columns, including the Net balance column, without affecting the existing dimension statement report.
Utilize Power Query in Excel: If exporting to Excel is still an option, you can use Power Query to automate the process of creating the Net balance column. Power Query provides a range of data transformation and manipulation capabilities that can help you perform calculations and add new columns based on existing data.
André Arnaud de Cal...
292,160
Super User 2025 Season 1
Martin Dráb
230,962
Most Valuable Professional
nmaenpaa
101,156