When to use lookup/sum versus when to refer cells in anaplan
I find a little bit confusing on when we would use the lookup or sum function rather than refer the cells in anaplan. Can you help me to explain more about this?
I also note that lookup is for looking up non-repetitive value on the source file, while sum is for summing up repetitive value on the source file. Depending on what the purpose is, lookup or sum is used. Is my understanding correct?
Answers
-
Take a look at this post, it might help you.
0 -
In order to understand whether to use SUM or LOOKUP, first you should identify the source and target modules based on your requirements. Once you identify the source and target modules, check the structure of both modules.
Sum: Many to One relationship, SUM function, is used for aggregating numeric values
Lookup: One to many relationship, LOOKUP function is used to retrieve a specific value
Examples:
SUM Function
Note: Target module dimension has to be a list format line item in source module
Formula: Employee Data.Salary[SUM: Employee Data.Location]
LOOKUP Function
Note: Source module dimension has to be a list format line item in target module
Formula: Location Module.Total Expense[LOOKUP: Location]
0