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.

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)