Sublist Function: Unable to retrieve data wrt Year

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
Answers
Questions
Solved2.40K 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??

Answered question
0

,y quick fix:
Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,switch(@Year="2018",1,@Year="2019",13,@Year="2020",25,@Year="2021","37",1,),#Year:Month))
skip Better Worse,%// using Layoutof Analysis::Year as Year

Let me know if there is a better way to optimize this

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

Latest Questions