Which approach is better? (Related to Text, Lists and Formulas)
I have a module which is dimensioned by one list. It has around 60k items. In this module there is one line item (Main_Text). I want to pull a string from this Main_Text line item and then use Finditem() function over that string.
Right now, the approach that I am using is to calculate them in two different line item. The second approach is to combine these two line items into one. (See the attached screenshot for better understanding)
Which one is better?
Please provide your insights based on some valid sources like Best Practices, Planual and Model Optimisation.
- Shubham Chaudhary
P.S.:- There are 5 different piece of info in that Main_Text so approach 1 will have 10 line items and Approach 2 will have 5 line items.