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.
I am search challenged! - need to show most recent call on lead list...
One of my reps has requested that I display the date of most recently completed phone call. I said "Sure, I can do that I think" - well.... maybe I can't..
We can't use a summary search for various reasons.
I've been reading up on dense_rank(), keep() partition, etc and my head is starting to spin.
There are a couple different examples here on the forums that I've tried, one results in an error and the other invalid expression.
For example, here is a criteria formula I've been trying to make work:
CASE WHEN ((dense_rank() over (partition by {call.internalid} order by {call.completeddate} desc) = 1) THEN 1 ELSE 0 END Steve Klett | Senior Developer
NetValue Technology
0