Sum a formula field [RESOLVED]

Hello everybody,

I have a formula field which shows sum of a database field against year and shows records arranged in a group. At the end of each group, I need to show sum of the formula field.

Example:

Mr. ABC
2005 $100
2006 $200
--------------
$300

Mr. XYZ
2005 $500
2006 $600
--------------
$1100

I am unable to show $300 and $1100 and Price is formula field and crystal report does allow me to summarize this field.

Thanks.

The summary options available on a Formula field depend on its return value.

If Crystal is not giving you the option to "Sum" then the formula's return value is not numeric. Post the formula.

This is the formula called forTotal which shows amount in Dollars.

VB Code:

Sum ({Maintenance_ComplaintDetail.Charges}, {@Year})

Another formula called Year is :

VB Code:

Dim strArray() As String
strArray = Split(CStr({Maintenance_Complaint.OrderStartDate}),"-")
Formula = year(cdate(Left(strArray(3),2) & "/" & strArray(2) & "/" & strArray(1)))

Thanks.

You cannot Sum a Sum.

Create a new formula for the customer total.
Sum ({Maintenance_ComplaintDetail.Charges}, {Your customer group field})

Thanks. Problem is resolved. I sum the field against first group.