Sum a formula field [RESOLVED]

[usamaalam]

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.

[brucevde]

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.

[usamaalam]

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

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

Another formula called Year is :

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

Thanks.

[brucevde]

You cannot Sum a Sum.

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

[usamaalam]

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