Saturday, October 27, 2018

Create a Saved Search of Transactions posting to Account Type = Expenses to show Amounts in reversed sign

Solution:
 
1. Search of transactions posting to various Expense Accounts shows Amount Debits or increases to Expenses as Negative and all Credits or decreases to Expenses are showing as Positive.
 
2.1  To reverse the sign, please Add Formula (numeric) field on the Results tab and click on the set formula icon and paste the below sql formula:
 
decode(sign({amount}),1, {amount} * -1, abs({amount}))

or 2.2 To reverse the sign of the Amount column, set the Function to Negate.  

No comments:

Post a Comment