-
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:…
-
Distinct Total Formula When Criteria Runs on System Notes
Hi all, I've created an Opportunity saved search to show opportunities that have been updated to a select few statuses this month. I want to get the projected total of all of the opportunity records that are not a certain status, however, I cannot summarize because there are multiple lines due to the system note criteria.…
-
NSC | Remove Duplicate Values when using NS_CONCAT in a Saved Search formula
Scenario User has a formula that uses NS_CONCAT function. However, it is returning the value more than once in the list. For example: Expected result: A1, B2, C3 Actual result: A1, A1, B2, B2, C3, C3 Solution Add the DISTINCT function in the formula: NS_CONCAT(DISTINCT({fieldid})) Note: Using SQL DISTINCT…
-
Can you use "Distinct" in formula to find only unique values?
Has anyone else seen this function? I used in it a transaction search: Sum(distinct{amount}). It removes any duplicate numbers with the same amount. Not quite what I want to do...What I am looking for is a way to use "Distinct" in a case formula, something like "Case when (distinct{line}) then {amount} end" This did not…