Query Help

Dear Experts,

I am working on a yield report to calculate the input output yield. I store the WIP in different warehouses.

For example,

Input A in Warehouse A with qty 10

Output A1 in Warehouse B with qty 8

So the yield for A should be (8/10)*100 = 80%

My problem is I don't know how to get the total quantity in warehouse B to be divided by total quantity in warehouse A for item A.

Is it possible to get the total quantity in one warehouse divided by total quantity in another warehouse in SAP B1?

Thanks & BR,

Leng