#Size Error while using Select Function

Join the discussion on using Formulas and Functions in Quantrix

Moderator: Moderators

#Size Error while using Select Function

Postby ShriShank » Wed Oct 18, 2017 3:55 pm

I would be grateful if you could help me resolve Select function issue.
In the attached model. I have 3 matrices. Matrix:FY16 report has data for FY16 and Matrix: FY17 Report has data for FY17. Also, Categories Type and Month are linked were as the other categories are not linked as they have different items Y-over-Y.

I am trying to pull the data, from both the matrices, into consolidated report matrix using Select function. In doing so, I get a “#Size”. How do I solve this issue?

Formula Used: Month=switch(@FY="FY16",select(FY16 Report::LineItem,and(@FY16 Report::LineItem,@FY16 Report::Department),and(@LineItem,@Department)),@FY="FY17",SELECT(FY17 Report::LineItem,and(@FY17 Report::LineItem,@FY17 Report::Department),and(@LineItem,@Department),"No Value"))

You do not have the required permissions to view the files attached to this post.
Quantrix Forum Member
Posts: 36
Joined: Mon Feb 13, 2017 9:25 am

Return to Formulas and Functions

Who is online

Users browsing this forum: No registered users and 1 guest