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.
In this module view, note that the FY20 result for KPI 1 is the correct result for the year.
This blueprint view shows the formulas and summary method used for the YoY KPI.
--Sam & Erin