Hierarchy level delay calculation

shiveshsingh — Thu, 03 Jun 2021 13:39:53 GMT

Hi All,

Please help in sorting out one logic.

Input data

Out Put Data

Data Understanding:

Data is doc id and Finished good wise and sorted based on parent child relation ship.

if you look on the levels, you can see the parent child relationship.

we have to start from the lowest level of child for a particular doc id and Finished good combination. So sorting is important

Let's check the i/p data.

for doc id = 1 and finished good = 167, lowest sort order is 8, that means it is the lowest level of child.

Now start calculating Level Delay, if there is no level below , it means it is 0. and total delay will be Delay + Level Delay.

This is for child.

If you move, one level up - you can see level as 2, so it is again child and not parent - so total delay = Delay + Level Delay.

moving one level up , level is 1. So this is parent for below 2 levels. Now for this, Level delay will be maximum of Total delay from it's child.

this way, we have to move up in the calculation.

Any help would be appreciated.

Re: Hierarchy level delay calculation

shiveshsingh — Fri, 04 Jun 2021 05:12:12 GMT