Hello! I'm new to this forum and although I have a couple of years of experience with Crystal I've always used it for simple reports.

I am having a problem with a Formula I created.

Global NumberVar TotalAmount;
TotalAmount := {Table1.TotalEarned} / {Table.DividebyValue};

The problem I am having is that Table1 might have more than one row for each Table1.User field. For example

Table1.User Table1.TotalEarned
2001              100
2004              200
2001              350
2003              450

The problem is that the formula only takes into consideration the firt 100 instead of the sum of 450 which is the total for both entries for User 2001.

How can I fix it so it sums all the values that the table could have for each user??