I have this query:
SELECT
((ms.ActualQuantityDeliveredinSalesUnits / od.CumulativeOrderQuantityInSalesUnits)*od.NetValueOfTheOrderItemInDocumentCurrency)-inv.NetValueOfTheBillingItemInDocumentCurrency AS ENRUTADO
,((od.CumulativeConfirmedQuantityInSalesUnit/od.CumulativeOrderQuantityInSalesUnits)*od.NetValueOfTheOrderItemInDocumentCurrency) - ENRUTADO AS CONFIRMA
,(od.CumulativeOrderQuantityInSalesUnits - od.CumulativeConfirmedQuantityInSalesUnit) * od.NetValueOfTheOrderItemInDocumentCurrency - CREDITO - HORIZONTE AS NO_CONFIRMA
,IF(od.OverallStatusOfCreditChecks = 'B' ,od.NetValueOfTheOrderItemInDocumentCurrency,0) AS CREDITO
,IF(od.OverallStatusOfCreditChecks = 'B' ,0,((IF(od.DeliveryBlock = 'ZD',1,0)*od.NetValueOfTheOrderItemInDocumentCurrency) - CREDITO)) AS HORIZONTE
FROM tb_csc_otr_orderdata` od
As you can see, in the first line I calculate the ROUTING and that calculation is the rest for the CONFIRM and later I use other calculated values. I can't think of how to use those calculated values within the same query, any ideas?