Category = sum of a group in another matrix

Generic selectors
Exact matches only
Search title only
Search in content
Search in all posts
Search in pages
651 viewsFormulas and Functions

Hi All,
I am attempting to have data entered into categories being the sum of a group name in another matrix
i.e. Matrix 1 has category names that are nominal codes and matrix 2 has category names that are cost types which are grouped by nominal code
I want the sum of the cost types from matrix 2 to appear in the correct nominal code in matrix 1.

Hopefully that makes sense.

Thank you in advance for your help.

Answered question

Without having a model to work with I suggest you look at using @Level function to return the nominal code and use it as an element of a select function.
If you could post a sample model with your setup I think it would help us help you solve your problem.

Answered question

Latest Questions

Complex Queries in Quantrix 1 Answer | 0 Votes
DataLink / JDBC / EXEC 3 Answers | 0 Votes
Wrong calendar calculations 1 Answer | 0 Votes
Script to delete rows 3 Answers | 0 Votes