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