Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Help, difference between two (2) data sets
Migrateduser
<p>Hi all, I need to calculate with a data item the difference between two columns of two different data sets.</p><p>Here is the example:</p><p>1st Query:</p><p>SELECT ID_MONEDA, SUM(I_COBRO)
FROM FAC_COBROS
WHERE O_EMPRESA = NVL(:p_o_empresa, O_EMPRESA)
AND F_LIQUIDACION = NVL(:p_f_liquidacion, F_LIQUIDACION)
AND N_LIQUIDACION = NVL(:p_n_liquidacion, N_LIQUIDACION)
GROUP BY ID_MONEDA</p><p> </p><p>2nd Query:</p><p>SELECT ID_MONEDA, SUM(I_PAGO)
FROM FAP_PAGOS
WHERE O_EMPRESA = NVL(:p_o_empresa, O_EMPRESA)
AND F_LIQUIDACION = NVL(:p_f_liquidacion, F_LIQUIDACION)
AND N_LIQUIDACION = NVL(:p_n_liquidacion, N_LIQUIDACION)
GROUP BY ID_MONEDA</p><p> </p><p>WhaT I need is to put in a table the result form (SUM(I_PAGO) - SUM(I_COBRO))</p><p>Each query can return 1, 2 or 3 columns.</p><p>Thank you very much!!!</p>
Find more posts tagged with
Comments
There are no comments yet