Discussion

3
Replies
1221
Views
Otto_Perdeck Member since 2010 9 posts
PEGA
Posted: October 30, 2015
Last activity: November 13, 2015
Closed

How to do VLOOKUP like lookup in an expression?

Suppose I have a Page List of Customers

 

Assume the Customer data model is - in pseudo notation - like this:

 

Customer {

ID : text,

Income : double

}

 

IDIncome
CE-1200
CE-2500
CE-3150

 

Now I would like to get the ID of the customer with the highest income. So in this example, that would be CE-2.

 

What PRPC expression would give me this (a la Excel vlookup)?

 

Thanks!

 

Otto

Case Management
Moderation Team has archived post
Share this page LinkedIn