Category = sum of a group in another matrix

2.42K 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