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

[sunny_talwar]

What are you expecting to see?

[Anonymous]

lets say if i select item 1, i would like to see the qty of all oils

sku	type	qty	sub qty (oil)
1	finished	10	39

thansk

[sunny_talwar]

May be this:

Sum(TOTAL {<[SKU NO], TYPE = {'Oil'}>}QTY) * Avg(1)

[Anonymous]

it should just show the figures from

3	,	Oil
4	,	Oil
5	,	Oil

I should be able to add the dim sub if required

result should be

Item	Type	Sub qty (type oil)
1	finished	12
1	finished	13
1	finished	14

thanks

[sunny_talwar]

I am not sure I understand the logic behind this? Would you be able to explain what you are trying to do?

[Anonymous]

sure!

Lets say i have an SKU NO 1, which is build of components (SUB) 3 and 4. Now i would like to display by expresion the Sub stock quantities from the SKU NO. The link which Sub belongs to which item is done in the relation table.

like sum({<Item = {'sub from the relation table'} , Type = {'Oil'}>} QTY)

Result should be

Dim	Dim	Expression (qty from sub oil)
SKU NO	SUB	QTY
1	3	12
1	4	13
1	5	14

the expression should also work if Dim SUB is removed

Dim	Expression (qty from sub oil)
SKU NO	QTY
1	39

Thanks Sunny

[varshavig12]

Your exp should work.

[Anonymous]

Hi, can you eventually add the expression to the sample .qvw attached? Would be great, as i couldnt get it work ...

Thanks Varsha

[varshavig12]

I'm using personal edition.