Sublist Function: Unable to retrieve data wrt Year

Solved4.75K viewsFormulas and Functions


I am trying to retrieve YTD revenue values from LayoutofMonth matrix to Final View Matrix.

I used following formula:

The formula works for the first year 2018. But, I am unable to retrieve the value of revenue from the next year onwards e.g 2019

What am I missing??

mgandy Answered question April 13, 2019

What’s the best way to approach Sau’s formula¬†where all Financial LineItem’s are updated? I’d prefer not to enter this formula for each individual line item.

mgandy Answered question April 13, 2019
You are viewing 1 out of 6 answers, click here to view all answers.