Hello All friends

I have a problem in Crystal Reports.

I have a table of with fields Item, Kg, Grams and data like:

Item | Kg | Grams
--------------------------
A | 5 | 250
A | 1 | 500
A | 1 | 350
A | 2 | 400

Now when I make the report in Crystal Report 8, it sums up the data as Total KG (5+1+1+2)= 9 and Total Grams (250+500+350+400)= 1500 at the end of the report.

Problem is that if Grams are >=1000 then it must add 1 to the Total Kg and Grams = Grams-1000.

But I don’t know that how can I do this in Crystal Report. I tried to add a formula field but don’t know the correct syntax of writing formulas in Crystal Report 8.

So please help me that how can I place the correct totals at the end of the report after calculating the weights.

I will be very thankful to you all. I need it very urgent please.