Sum from another field

[Anonymous]

Hey friends

i have a problem showing the the inventory qtyf rom another field which is linked (BOM).

Basically i have 3 tables

1. Inventory figures by Item

2. item relations (Multilevel BOM)

3. Item data ( item informations such  type and so on....)

Now i would like to show the stock of an subassambly by expression. Tried planty of things, but somehow i just dont get it done. how should the expression look like?

i have attached a sample .qvw which is reflecting my RL data

Would be great if somebody could help

Many thanks and rgs

Rob

[varshavig12]

If you select SKU NO in list box,

you will get the result in text box using this exp:  =sum({<[SKU NO]={"$(=concat([SubAssembly],'","'))"}>}QTY)

After this, it becomes little confusing.

May be this can help you to proceed further.

[varshavig12]

What I think is the Stock is 10, not 14.

[Anonymous]

exactly

[Anonymous]

just have tried your expresion, but i get always value 0 in the text box..

tought initialy that it would be much easier to make a vlookup like function.

maybe better as calcualted dimension`?

thanks Varsha

[varshavig12]

But it works,only in text box and any other selection makes it zero.

I'm not able to provide a better solution because your expected output is bit confusing.