Amount Values in Analytics Finance Cube

Hi there,

I'm hoping someone out there can help me understand the 'Amount' values in the Analytics Finance Cube.

The key ones seem to be:

• Transaction Amount
• Debit Amount
• Credit Amount.

I think the Transaction amount is both sides of the double entry, so unless you break by GL, this is always 0 ?

I'm doing a simple pivot of all Pledge Payments by year, so I've filtered by Pledge Payment Received and Adjustment to Payment. and I'm using SUM(Debit Amount) for my value.

I have numbers, it looks pretty good.

However, I notice that a negative adjustment to a payment (e.g. a correction), is listed as a positive value in both Debit Amount and Credit Amount, so my total SUM is too high.

If I use transaction amount, I get a zero.

Can anyone explain whey I don't get a negative value for the negative adjustment to payment?

thanks,

Dara