Hello,
I'm kinda stuck on this one that I would like to solve without altering the script :
I have a data table with components that are parts of articles.
Both components and articles have stock values.
One table says article 1 = made up of component A, component B, component C, ...
(like 1 = 5*A + 3*B + 1*C, 2 = 1*A + 3*D, ...)
Other table says stock values etc. for each component and article
(like 1= 50, 2=20, A= 10, B=5, ..)
In script is defined that in the first table dimension = ART and expression is COMP
in second table dimension = ART (both articles and components)
I can reverse and tell what components are used in what articles:
dimension 1 COMP, dimension 2 ART.
Now I would like to show stock value as expression but although they are written in the same
notation, I cannot get stock value next to dimension 1 because stock value is linked to ART.
I am searching for something like
sum({$<ART= {$(COMP)} stockvalue) but than line by line
(like "give me stock value for ART = COMP mentioned in this line's dimension 1")
All help is appreciated
Davy