Sublist function: Unable to retrieve data while using sublis

Question

2.69K viewsAugust 31, 2017Scripting

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??

score 0 · Answer 1 · 2017-08-31T17:46:48+00:00

Sorry to post this in scripting section. Will post it again in Formula Section. I dont know how to delete a post.