Nada Ahmed
08/29/2024, 5:56 PMCeligo AI
08/29/2024, 5:57 PMAI 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:
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.
******Celigo AI
08/29/2024, 5:57 PMSlack 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
Celigo AI
08/29/2024, 5:57 PM