Help me for Weight Conversion in Crystal Reports (8)…

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.

I would create 2 formulas; 1 for the grams and 1 for the kgs. Do your normal ttals, but make them invisible (suppressed). You rformauls for the grams would be

if {your subtotal of grams} >= 1000 then
{subtotal of grams} - 1000

your formula for the Kgs would be
if {your subtotal of grams} >= 1000 then
{subtotal of kgs} + 1

Use the formulas as your totals.
I think this should give you the direction, if the syntax is not entirely correct.

You take grand total of two fields in for example group footer section. In group fotter u make two forumlas and dont display that total field and then give ur logic of greater then thouse so subtract one or so.

You can ge the result easily.