Challenge

Create a formula field, Parent Annual Revenue on Account that displays an Account's Parent or Grandparent's Annual Revenue. If the Account has a grandparent (2 levels up) fetch its Annual Revenue. If it only has a parent (1 level up), use the parent's Annual Revenue. If it has no parent, the field blank should be blank.

Field Type: Formula (Currency)
Field Label: Parent Annual Revenue
Field Name: Parent_Annual_Revenue
Description: Fetch and display if the annual revenue of the account highest in the hierarchy

Example Scenarios:

Scenario 1:

Input: Account Hierarchy: Grandparent -> Parent -> Child (Current Account)
Result: Parent_Annual_Revenue = Grandparent's Annual Revenue
Explanation: The account has a grandparent. The formula field fetches the annual revenue of the grandparent.

Scenario 2:

Input: Account Hierarchy: Parent -> Child (Current Account)
Result: Parent_Annual_Revenue = Parent's Annual Revenue
Explanation: The account has a parent, but no grandparent. The formula field fetches the annual revenue of the parent.

Scenario 3:

Input: Account Hierarchy: Sole Account (Current Account)
Result: Parent_Annual_Revenue = blank
Explanation: The account does not have a parent. The formula field should display an empty value.