Sublist Function: Unable to retrieve data wrt Year

Solved5.95K viewsFormulas and Functions
0

Hello,

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

I used following formula:
Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,1,#Month))

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
0

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.