When to use Lookup & Sum function

zaibhamid81

Hi all,

 

Could you please explain when to use Lookup or SUM function, I remember there was a lesson in MB Level 1 course but I am unable to find it.

 

I will really appreciate if someone can provide a link to the lesson or explain the difference in term of when to use them. 

 

JH

KirillKuznetsov

@zaibhamid81 

Here is a good visual representation of the difference between the functions attached to the post by @MCRIST : SUM vs LOOKUP - Visual Representation - Anaplan Community

I will add you some more links for better understanding below:

On-Demand courses:

The LOOKUP Function - Anaplan Community

The SUM Function - Anaplan Community

Additionaly please have a look at: Compound Functions: SUM, LOOKUP, SELECT - Anaplan Community

More use cases can be found here: Function vs Function: SUM vs LOOKUP - Anaplan Community

 

zaibhamid81

Thanks so much @KirillKuznetsov .

This is so helpful.