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.
Neither of those is working for me. I’m not sure what the issue is. I have values in those fields.
