When to use Lookup & Sum function
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.
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:
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 Community0
Thanks so much @KirillKuznetsov .
This is so helpful.0