Order of Lookups and SUM in formulas
I was going through a best practice video which mentioned that the order of lists in the module can help improve the performance if the lists are ordered similar to their order in General Lists section (because indexing becomes easier for the engine).
I was wondering if there is a similar best practice when it comes to the formulas itself?
- Is there an order in which we should be putting the SUM/LOOKUP functions (assuming the formula has 2 lookups together)?
- If you are multiplying 2 different numbers say an assumption % (from a small assumptions module) and a total number (from a module of same size), does the order of the selection matter in terms of performance? E.g. Is "Assumption%[Lookup:X] * Total" quicker than "Total * Assumption%[Lookup:X]" ?
Looking forward to the response from the community.