Question:
Hello everyone !!!
Can I get some tip from you?
In a query, the materials (SKU’s) of a Hierarchy must be showed until the last of the 5 levels (nodes) and I’m using in the rows of this query the products opened by Attributes, instead of a hierarchy. Each node of the hierarchy corresponds to an attribute of 0MATERIAL.
Node 1 FRANCHISE
Node 2 ---- GROUP
Node 3 ---- FAMILY
Node 4 ---- PRODUCT
Node 5 ---- VERSION
SKU’s ---- MATERIAL
A certain column is expected to bring the values (by means of formulas) for the rows of SKU’s .
For the Nodes 5 I want them to receive only the summation of the SKU’s and the respective above the summation of the Nodes below.
Now, the nodes are behaving just like the formulas that are already working for the rows of SKU’s…
I don’t want this.
To do this, I’m using Standard Functions BEx to bring the correct expected values.
I started using the Function LEAF that shows in a column (Test LEAF) the value “0” for the nodes and “1” for the SKU’s.
But I couldn’t find a way to add the values for the nodes, but only for the SKU’s.
In another column I’ve made a new Boolean formula in order to bring this. Something like:
(‘Test LEAF’ == 0) * ( ???????????) + (‘Test LEAF’ == 1) * ‘Formula already working’
Could someone help me on this missing part of the formula?
Thanks in advance
Marcos Itri Trumpauskas
BW Consultant
_________________
Marcos Itri Trumpauskas
BW Consultant
Answer:
Did u get any solution?