User defined function
I am searching for a User defined function that works in Hierarquical
structures.
Hierarquical structures contents elements at a level (father) that are
divided in different elements at the next level (sons). The Work Break
Down Structure used in Project management is one of them, usually each
element has a identifying code like this:
CODE MH
1
1.1
1.1.1 30
1.1.1.1 10
1.1.1.2 20
1.1.2
1.1.3
1.2
1.3
1.4
If an element has an assigned value (for example man hours MH), the "father"
has value of the summation of its "sons" (30=10+20). Calculation is made
this way up to the top of the structure.
Is it possible to develop a function to calculate the sum of the variable
(MH) at any level? (provided that values at the lowest level are known)
|