I am creating a comercial invoice that has a "details a" area that lists the parts ordered along with the quantity.

I have then created a formula;

formula = Sum ({SO_InvoiceWrk.QuantitySh

ipped})

in order to calculate the total number of items shipped in an invoice. I have placed this field in the Page footer.

The SO_InvoiceWrk.QuantityShipped is a Database Field. The numbers in the Quantity field are accurate. On 3 reports the qty is showing;

1

1,1

1,2,1

Those numbers are accurate based on the quantity shipped. However the sum field which I have created is respondig with;

1

3

10

Can anyone tell me why this is not adding correctly?

I have changed the extension of the attached report from .rpt to .jpg to allow it to be uploaded. In the attachment the field in question is located at the bottem under NET WEIGHT IN LBS. I have changed the forumla to sum the quantity instead of what I am really after which is Net Weight because the quantity under quantity shipped is smaller.

SO-Invoice2.jpg