Skip to Content
0
May 28, 2020 at 01:49 PM

Recursive calculations using Hierarchy function

126 Views

I'm working on BOMs and I need to calculate start date and due date of any single node of one tree result of applying Hierarchy function.

I know the due date of the root code and, applying the specific leadtime of the node, I calculate the the start date.

For each subsequent node of the tree, the due date will be exactly the start date of the father node, while the start date will be the due date minus the specific leadime of the node.... and so on till the end of the tree.

Is there any simple way to do this in only one call of the Hierarchy function without any other evaluation on the result?

Thanks

Antonio