Using Descriptor in select or sumif?

Solved4.44K viewsFormulas and Functions
0

I’m trying to get the sum of certain values in a matrix based on the value of a descriptor item.

I’m using the descriptor to associate payments with different loans and want the total payments made to each loan.

Does anyone know if the descriptor values can be accessed for this purpose from a select or sumif, or some other conditional formula?

Thank you,
Stefan

1

Dear Stefan,

I have attached a model that shows how to accomplish this using a select statement, which is the preferred way of doing it. The model is in Quantrix version 5.0. Let me know if you need an earlier version.

Cheers,
Brian

braddo Posted new comment September 25, 2020

To summarize Brian’s answer: You can use the function @descriptor(Category, Descriptor Name) inside a select function to achieve this.