Topic: Округление вычисляемого поля
Подскажите как округлить такой запрос в вычисляемом поле:
(
(SELECT cost FROM goods WHERE amount.id_goods=goods.id)*
(
((SELECT TOTAL(amount_delivery) FROM amount_delivery WHERE amount_delivery.id_client=client.id AND
amount_delivery.id_goods=goods.id AND amount_delivery.id_lot=lot.id AND amount_delivery.id_expdate=expdate.id) +
(SELECT TOTAL(amount_move) FROM amount_move WHERE amount_move.id_client1=client.id AND
amount_move.id_goods=goods.id AND amount_move.id_lot=lot.id AND amount_move.id_expdate=expdate.id)) -
((SELECT TOTAL(amount_move) FROM amount_move WHERE amount_move.id_client=client.id AND
amount_move.id_goods=goods.id AND amount_move.id_lot=lot.id AND amount_move.id_expdate=expdate.id) +
(SELECT TOTAL(amount_shipment) FROM amount_shipment WHERE amount_shipment.id_client=client.id AND
amount_shipment.id_goods=goods.id AND amount_shipment.id_lot=lot.id AND amount_shipment.id_expdate=expdate.id))
)
)