Crystal Reports Need help with summarizing totals

Message

   Here is the issue:  Multiple line items on an invoice and multiple lines of recognition against them. 

The data looks like this:
   Sku       Qty     Rate      Total             Recognition Total
1. UNCR      100     200       20,000                     0.00
2. UNCR1    200     190       38,000                 4000.00
2. UNCR1    200     190       38,000                 5000.00
2. UNCR1    200     190       38,000                 1000.00

The first 4 items (Sku, Qty, Rate, Total) are in the DR Table the Recognition Total is in the Recognition Table.

I am trying to get an invoice total for the skus which should be 58,000.  But with a right join I get 38,000 and a left join i get 20,000.  If I do a sum of the total field first through a formula I get 134,000.  Basically it is adding the 2nd line 3 times because it has multiple lines of recognition against it.  

How can I get the report to only give me the total value of the first two lines without including all of the other lines?  Someone was thinking a "Distinct" formula but I am not familiar with this in Crystal.

Any suggestions?  Need more information?  Please let me know...  Any help is appreciated!!  Thanks!!!