Netting off Values

[Pushpendra_1]

Hi,

I have the data in below format and I want to get the net values against each Purchase Order number and the line item

Can someone please help?

Thanks,

[RolandSchubert · Accepted solution]

Hi @Pushpendra_1 ,

do you expect as the "net value" the aggregation of the different lines per purchasing document/line item? You should use a SUMMARIZE tool and set "Purchasing document" and "Item" to "GROUP BY" and  "Quantity" and "Amount in doc.curr" to "SUM".

Does this help?

Best regards

Roland

[Pushpendra_1]

Thank you so much Roland. That really helped.