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

When is use the following formula:
Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,1,#Year:Month))
skip Better Worse,%// using Layoutof Analysis::Year as Year

I can get the summation of actual wrt month and year but I cannot change the starting month to oct of specified year. It still refers to Oct of 2018.

when i change the formula to:
Revenue=sum(sublist(LayoutofMonth::Year:Month:Revenue,#Year:Month:Oct,#Year:Month))
skip Better Worse,%// using Layoutof Analysis::Year as Year

I get #Bounds error

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