I am looking for assistance to understand best practice/performance implications between 2 different approaches of getting a list item parent in a formula. Imagine I have 3 modules: X, Z, and System Module. The System Module contains Parent line item with formula PARENT(PARENT(ITEM('List Items'))). I want to return this same parent item in a new module and line item and I can use either method 1 or 2:
Method 1: PARENT(PARENT('Module Z'.'Child Line Item'))
Method 2: 'System Module'.'Parent'[LOOKUP: 'Module X'.'Child Line Item']
Is it better to use Method 2 as it follows the idea of "calculate once, refer to many times" , or is it better to use Method 1? Curious how the engine evaluates the parent() function and nested parent() functions.