New Contributor

Re: Erin Lauterbach & Sam Wong - Model Building Problem Solving

@fabien.junod — Great question!

I was able to get a solution by using the OFFSET() function instead of a [LOOKUP]. This will allow you to set the Summary to Formula.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/OFFSET.html?Highlight=offset

In this module view, note that the FY20 result for KPI 1 is the correct result for the year.

Summary Calculation YoY.jpg

This blueprint view shows the formulas and summary method used for the YoY KPI.

Offset Collect.png

 

--Sam & Erin

 

Tags (1)