Contributor

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.

Capture.JPG

Tags (1)