SCENARIO
User is using OneWorld and wants to create a Saved Search for Accounts specific to a Subsidiary.
SOLUTION
1.) Navigate to Lists > Search > Saved Search
2.) Select Account
3.) Go to the Results tab, remove fields and add the following:
Name | Summary Type: Group
Formula (Text) | Summary Type: Maximum | Formula: NS_CONCAT({subsidiarynohierarchy})
4.) Go to Criteria tab > Summary subtab
Option 1
Summary Type: Maximum
Field: Formula (Text)
Formula: CASE WHEN NS_CONCAT(DISTINCT {subsidiarynohierarchy}) = '{subsidiary name}' THEN 1 ELSE 0 END
Replace {subsidiary name} with your child subsidiary name
Formula (Text): Is | 1
Option 2
Line 1:
Summary Type: Maximum | Field: Formula (Text) | Formula: NS_CONCAT({subsidiarynohierarchy}) | Formula (Text): is | Subsidiary Name (with no Hierarchy)
Line 2:
Summary Type: Count | Field: Subsidiary (no hierarchy) | Equal to 1
Both options will have the same results
5.) Rename Saved Search
6.) Save and Run
Result:
The Saved Search will display the accounts exclusive for a particular subsidiary.
Please also check:
NSC|How to create an Account Dataset to check for available accounts for a particular subsidiary?
I hope this helps! 🙂