Crystal Reports: Editing Decimal Places in Invoice Quantity Fields

SOLVED

Hello,

I am trying to reduce the number of decimal places shown in the Quantity ordered, quantity shipped, and quantity backordered fields on my invoice template generated in Crystal Reports (a custom made OEINV.rpt)

Each field is currently showing four decimal places in each field (i.e 1.0000).

In the I/C Setup Options in Sage 300 ERP, the option 'Allow Fractional Quantities' is checked.

When I open the invoice template in Crystal Reports and select edit formula for the quantity amounts, the following formula is present:

IF ({OEINPR3.LINETYPE}<> 1) THEN
""
else
  TOTEXT({OEINPR3.QTYORDERED},ToNumber({?QTYDEC}))

is there a way to edit this formula to reduce the number of decimal points presented on the invoice to 2?