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
Answers
Questions
346 viewsFormulas and Functions
0

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
0

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

Pareto – 80/20 Rule 2 Answers | 0 Votes
Setting a cell to a fixed value 1 Answer | 0 Votes
Sum formula facing SIZE issue 2 Answers | 0 Votes
Model becomes slow 3 Answers | 0 Votes