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.
NSC | Saved Search Formula to Show Same Value in NS_CONCAT with DISTINCT Formula
Scenario:
A user is working with a Project Saved Search, specifically focusing on extracting unique Sales Orders and their corresponding Total Amounts.
The initial approach involved using a formula to concatenate the Sales Order number and Amount, ensuring uniqueness by combining them into a single string.
- Initial Formula: REPLACE(NS_CONCAT(DISTINCT(CASE WHEN {transaction.type} = 'Sales Order' THEN ({transaction.number} || ':' || {transaction.totalamount}) END)),',','
<br>')
This resulted in a format like "SO01:1000<br>SO02:1000", where the Sales Order number and Amount are separated by a colon and different entries are separated by line breaks.
Learn how to Refer A Member | Earn the Answer Accepter Badge | Be the Content Creator of the Quarter | Vote for the content you want to see!
2