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.

Views: 37

Reply to This

Replies to This Discussion

Would something like this work for them?


Thanks for the suggestion.  I will see if this will work for them.


The Sage Intelligence Blog

Like Sage Intelligence?

Follow @SageSupport

© 2017   Created by Sage Alchemex.   Powered by

Badges  |  Report an Issue  |  Terms of Service