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))
                                                                                    
)    
             
)

Re: Округление вычисляемого поля

Привет,
Попробуйте это так:
(select round((x+y-z) * (a/b),2)).
Посмотрите на этот простой пример.
С Уважением,
Derek.

Post's attachments

Attachment icon round.zip 336.15 kb, 225 downloads since 2019-07-07