Using Descriptor in select or sumif?
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
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.