Debit amount and Credit Amount to Net Total

Summary:

In the transaction matching integration, we have a column for Dr Amount and another for Cr Amount; however, there is no net amount provided in the file. I need to map the total amount to the amount in the Map dimension, but I lack a total column. Could anyone suggest SQL scripts or provide guidance on how to effectively map the dimension amount to the total?

Content (please ensure you mask any confidential information):

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

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