nvl({debitamount},0) + NVL({creditamount},0) corre...
# ask-stanley-ai
n
nvl({debitamount},0) + NVL({creditamount},0) correct it to show the credit with negative sign
c
AI generated answer (using internal Slack threads):
Based on the conversations, it seems like you want to adjust the formula
nvl({debitamount},0) + NVL({creditamount},0)
to show the credit amount with a negative sign. You can achieve this by multiplying the credit amount by -1. Here's how you can modify your formula:
Copy code
nvl({debitamount},0) - NVL({creditamount},0)
This formula will subtract the credit amount from the debit amount, effectively making the credit amount negative. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.836037457
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.830241382
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.829915941
Please provide your feedback on this answer.