Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have two tales Schedule Lines and Detail.
We need to pull quantity from Schedule line table where Purchase document and Item from detail table matches with Purchase document and Item Schedule line table.
Attached is the data sample.
Below is the excel logic in source file for reference.
=SUMIFS('Schedule Lines'!$J$1:$J$1353,'Schedule Lines'!$A$1:$A$1353,PO_Detail!A1058,'Schedule Lines'!$B$1:$B$1353,PO_Detail!B1058)
where J = quantity
A= purchase document
B= Item.
Thanks,
Thanks,
Any Suggestions please.
Thanks..
Hey,
Maybe something like this? (See attached qvw)
Had to separate the two tables in your Excel sheet, hence the Excel attachment.