Sublist Function: Unable to retrieve data wrt Year

Solved4.76K 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

Thanks for the reply.
But my aim with this model is to get the sum of the revenue(Year to date) from the starting fiscal year month of Oct to the month selected from the drop down menu in the category month.
And when I change the year it should sum again from oct for that year to the month selected.
e.g
If i chose month June, then for year 2018 the actual should be $40
and for year 2019 it should show actual as $6000

You are viewing 1 out of 6 answers, click here to view all answers.