[Stackoverflow] [Progress OpenEdge ABL] Progress Database 4GL - Math calculate for export file

[Joe]

The statements below will execute. However, I want the wShipment.Volume divided by 1728 and export that result.

For example, if wShipment.Volume is 3456, then it should export the result 2 to the report.

OUTPUT TO \\tsclient\U\All_Orders_item.csv.

FOR EACH r4_wms.wShipmentDet NO-LOCK,

FIRST r4_wms.wShipment OF r4_wms.wShipmentDet NO-LOCK where wShipment.shipmentNO>6500 and wShipmentDet.Owner="MIDEAUS",

FIRST r4_wms.wOrder OF r4_wms.wShipmentDet NO-LOCK,

FIRST r4_wms.wOrderline OF r4_wms.wShipmentDet NO-LOCK
BY wShipment.ShipmentNo DESC:

EXPORT DELIMITER ","

wOrder.OrderNo

wShipment.Volume

wShipment.Weight SKIP.

END.

OUTPUT CLOSE.

Continue reading...