formula numeric to sum the amount debit and credit in one column in the saved search

AI generated answer (using internal Slack threads):

Based on the conversations, to sum the amount debit and credit in one column in the saved search, you can use a formula numeric field. The formula would be

nvl({debitamount},0) + NVL({creditamount},0)

. This formula will add the debit amount and credit amount together. If either of these fields is null, the

nvl

function will replace it with 0, ensuring that the formula does not result in an error. Here is a step-by-step guide on how to do this: 1. Go to your saved search and click on the 'Results' subtab. 2. Click on 'New Field' to create a new column. 3. In the 'Summary Type' dropdown, select 'Sum'. 4. In the 'Field' dropdown, select 'Formula (Numeric)'. 5. In the 'Formula' text box, enter

nvl({debitamount},0) + NVL({creditamount},0)

. 6. Enter a label for the column in the 'Label' text box. 7. Click 'Save'. This will create a new column in your saved search that sums the debit and credit amounts. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******