Very Very Urgent

[buh]

I am having a table which contains two columns as "Status" and "Amount". Status may be Completed or Pending and the corresponding Amount.At the end of the report, i.e. in the Report Footer, i want to show the total amount for Pending Status and the total amount for Completed Status.I am able to get the Number of Status Completed and the Number of Status Pending.But I am not able to get the total amount of Completed Status and total amount of Pending status.

Please help me in this subject.
Regards,
Buhari

 

[synapsevampire]

This sounds too simple...

Use a summary field and sum them. Place the field that you wish to count or sum into the detail, right click it, and select Insert Summary.

If it's a conditional count or sum, then use a running total and select under Evaluate:

Use a formula

Enter the condition which meets your criteria.