When to use lookup/sum versus when to refer cells in anaplan

phuongle
phuongle
edited March 2024 in Modeling

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

  • rob_marshall
    rob_marshall

    @phuongle

    Take a look at this post, it might help you.

    https://community.anaplan.com/discussion/156581/what-is-the-difference-of-sum-lookup-select

  • Dikshant
    Dikshant
    edited March 2024

    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

    image.png

    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

    image.png

    Note: Source module dimension has to be a list format line item in target module

    Formula: Location Module.Total Expense[LOOKUP: Location]

Categories