Re: Erin Lauterbach & Sam Wong - Model Building Problem Solving
Same as Nicolas, I have a question around the Collect() function.
Sometimes, we use it to show some KPIs (line items in the original module) and the the year on year growth using the formula "Collect / Collect [LOOKUP: Prior Year] - 1" where Collect is the line item using the formula collect()
The big problem, and I haven't found a solution that is satisfactory, is that we cannot set the summary = formula when using lookup. Hence, the YY% for the full year is not accurate.
Any suggestions? We use collect because we want to show the KPIs as row and the Forecast, Prior Year and Y/Y% as columns.