Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Getting maximum value from sublist
Hey, all
I think this should be easy enough, but I'm really not managing to comprehend the documentation. We've got a Custom Field on Contact - custentity_mksleadscore - which is a Decimal Number
A Customer, obviously, can have multiple leads. We'd like to create a Custom Field on Customer (Customer, Prospect, Lead), which shows the maximum value of the leadscore from the associated contacts. We tried :
max({contact.custentity_mksleadscore})
Which gives a value, but it actually gives the value for the lower one, which happens to be the one first in the list of contacts.
Thanks!
0