I am working on a purchasing Gridview and I need to use only the "WA" quantities. Our qty on hand includes all of our warehouse and I want to include only our Trenton warehouse. I have 2 .gv's to run this:

The first one is "I/C Items (1,3) Master" = Items to order.gv

The second is "I/C Item Locations Master" = Trenton qtys.gv

Using the Trenton qtys.gv I am calculating the amount qty of WA: IF({Loc} =" WA",{Qty on Hand Plus}-{Qty Shipped not Cost},0) this works fine.

I want to bring that calculated column into my first Gridview to calculate how many we need to order. How can I do this? I used: GETLINKEDVALUE("Trenton Qtys", "Item #", "Trenton", 0). This shows nothing in the column. How can I see only the WA (location) qtys in my "I/C Items (1,3) Master" View?