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):