@shreyak.garg Great question. I believe the answer is no. The formula is broken down into the various parts and the SUMs are always completed first., then the LOOKUPs, then the remainder. Also if you have multiple SUMs or multiple LOOKUPs, the order doesn't matter. However, for readability, and consistency, I advocate keeping the order the same. So if your dimension order is Customer, Product, Time and you have a double lookup, I would have something like: ...[LOOUKP:Mapping.Customer, LOOKUP:Mapping.Product] each time you need to use it It is important though to ensure that the same SUM or LOOKUP is not repeated within the line item formula. If it is, then it should be split in it's own line item; that way the formula is only performed once, not many times. Also, I'm sure you know that you should avoid SUM and LOOKUP in the same [], as per Planual 2.02-08 I hope that helps David
... View more