- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

01-29-2019
07:27 AM

01-29-2019
07:27 AM

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

Hello both,

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.