RE: Debit – Credit SQL Formula
I am trying to write what I thought would be a pretty simple formula for a transaction search
{debitamount}-{creditamount}
It is just coming up blank.
I am trying to get both invoices and journals onto a single search and do a summary total, which I cannot do using the transaction total since that doesn’t exist for a journal.
Anyone know a trick to get this to work?
I’d also like to get this to work in an Analytics dataset as well.
I was able to get this to work in a dataset
CASE WHEN {transactionlines.accountingimpact.debit#currency_consolidated} is NULL THEN 0 ELSE {transactionlines.accountingimpact.debit#currency_consolidated} END)-(CASE WHEN {transactionlines.accountingimpact.credit#currency_consolidated} is NULL THEN 0 ELSE {transactionlines.accountingimpact.credit#currency_consolidated} END
Thanks for the help!
