Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Friends;
I would ask your help for the next case.
I have a table that comes with the following columns documnet Type, Units, Invoice, now well what I do is subtract units Units when Document Type ZRE and ZVLO have the same number of Invoice.
Document Type Invoice Units
ZVLO April 1234
ZRE February 1234
In this case subtracting 4 ZVLO 2 ZRE but the condition is the same as is Invoice example.
I really appreciate your help much because I failed to do so.
Regards.
-------------------
Amigos;
quisiera pedir su ayuda para el siguiente caso.
tengo una tabla que viene con las siguientes columnas Documnet Type, Units, Invoice, ahora bien lo que quiero hacer es restar a Units las unidades cuando en Document Type ZRE y ZVLO tengan el mismo número de Invoice.
Document Type Units Invoice
ZVLO 4 1234
ZRE 2 1234
En este caso restar a 4 de ZVLO 2 de ZRE pero la condición es que Invoice sea el mismo como el ejemplo.
En verdad agradeceré mucho su ayuda ya que no he logrado hacerlo.
Saludos
Please share the sample data with expected output
You expect this response?
Document Type Units Invoice
ZVLO 2 1234
ZRE 2 1234
The expected response would be like Raúl
Document Type Units Invoice
ZVLO 2 1234
ZRE 2 1234
ZRE even that will not show the final data would only ZVLO .
Thank you very much for your help.