I have created a container using the GL Detail Posting table. The table contains fields for DebitAmount and CreditAmount. I have an expression, Amount, which is the DebitAmount minus the CreditAmount. I've created a Pivot Table which shows the amount.
The client would like the Credit Amounts to show without the minus sign. Has anyone been able to do this? I've tried several ways both in an expression and in the pivot table and can't seem to make it work.
As always, thanks for any help.
Thanks for the suggestion. I will see if this will work for them.