Hi, I am new to crystal reports and having trouble with the Sum function.

I am using Crystal reports 8.5 with Raisers Edge, I hope this is the right forum

I want to sum the gift amounts given by distinct Constituents. I tried

Sum({GIFT.Amount},{GIFT.CONSTIT_ID})

using crystal syntax AND basic syntax but got the error

"The summary / runing total field could not be created."

I have:
GIFT.CONSTIT_ID            GIFT.Amount
1111111                          $50
1111111                          $10
2222222                            $5
2222222                          $20
2222222                          $25

and I want

GIFT.CONSTIT_ID            GIFT.Amount
1111111                          $60
2222222                          $50

I would use the insert summary feature, but it still includes each unique gift with the total on the Footer.

Thanks in Advance

group by ID,