For more information, please refer to this announcement explaining best practices for getting answers to questions.
Manager Hierarchy-Is it possible to control both top and bottom level managers using FF?
Summary:
We have a requirement where we need to restrict the managers at both the levels - Top and bottom of the hierarchy.
Example: if below are the Job levels of the managers in a Hierarchy
20100>20200>20300>20400>20500>20600>30100>30200.
Here is the requirement to roll up the managers in the hierarchy
1.For the Managers with job levels below 20300 , always the Hierarchy should start from 20300.
2.In the top if the hierarchy hits any of these Job levels 30100 or 30200 or 30300, the hierarchy should stop at that level.
Based on these 2 conditions, the Hierarchy in the above example should be changed to 20300>20400>20500>20600>30100
The formula is able to restrict the hierarchy at the starting point, it is changing the hierarchy to 20300>20400>20500>20600>30100>30200.