Sublist function: Unable to retrieve data while using sublis

Discuss the new Quantrix 4 Scripting Feature!

Moderators: Ben G, Moderators

Sublist function: Unable to retrieve data while using sublis

Postby ShriShank » Thu Aug 31, 2017 10:25 am

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??
You do not have the required permissions to view the files attached to this post.
ShriShank
Quantrix Forum Member
 
Posts: 27
Joined: Mon Feb 13, 2017 9:25 am

Re: Sublist function: Unable to retrieve data while using su

Postby ShriShank » Thu Aug 31, 2017 12:46 pm

Sorry to post this in scripting section. Will post it again in Formula Section. I dont know how to delete a post.
ShriShank
Quantrix Forum Member
 
Posts: 27
Joined: Mon Feb 13, 2017 9:25 am


Return to Scripting

Who is online

Users browsing this forum: No registered users and 2 guests