"Applies to order" in formulae

TimWard70

Does the order that we list LOOKUP: \ SUM: arguments also need to be consistent with the "applies to" ordering?

Logically it would as I believe the reason behind this is to do with how Indexes are built in the background but am uncertain and would love confirmation.

TristanS

@TimWard70 please refer to post below

https://community.anaplan.com/discussion/52961/order-of-lookups-and-sum-in-formulas

SriNitya

https://community.anaplan.com/discussion/32934/oeg-best-practice-dimension-order

Heard about the dimension order but looking to hear from community regarding your question.

TimWard70

Many thanks @SriNitya, I have read that article a number of times and couldn't see an answer to my question, hence asking the group. If I have missed something in the article that does explain, I'd love it if you could point it out for me. T

TimWard70

@TristanS Very helpful, thank you.