You need to sign in to do that
Don't have an account?
Sai Harshitha Bandlamudi
How to write a formula for the following 3 level hierarchy picklist
I have a 3 level hierarchy. Object "School district" with picklist values "Zone 1","Zone 2","zone 3","zone 4". Each zone has their own level as picklist values such as "Level 1",Level 2", "Level 3" ",Level 4". If level 1 is chosen, the score is 1 and if level 2 is chosen the score is 2 and so on. Now i have to write a formula on "school district" level that does an aggregation of all zones( which is an aggregation of the minimun score of levels chosen) returing the minmum values .
Example: "Zone 1 " if level 3 is chosen and
in "Zone 2" if level 4 is chosen and
in "Zone 3" if level 1 is chosen and
In "Zone 4" if level 3 is chosen
then at school district level it should return "1" as the value.
Example: "Zone 1 " if level 3 is chosen and
in "Zone 2" if level 4 is chosen and
in "Zone 3" if level 1 is chosen and
In "Zone 4" if level 3 is chosen
then at school district level it should return "1" as the value.