How can I exclude "- None -" from a saved search? ...
# suiteanalyticsz
zaanton
02/12/2020, 2:56 PMHow can I exclude "- None -" from a saved search? I'm creating a Saved Search for A/R and they do not want transactions without a Name (Name "- None - ") included in the final totals of their results.
a
Aria Ghahari
02/12/2020, 4:43 PM@zaanton In your criteria, from the drop down select:
none of: -None-
z
zaanton
02/12/2020, 4:47 PMHi Aria,
Unfortunately that is not possible, as - None - cannot be selected.
a
Aria Ghahari
02/12/2020, 4:48 PMWhat field are you doing this on?
Aria Ghahari
02/12/2020, 4:52 PMDon't search for anything. Please just show me a screen shot of the list unfiltered.
It might be called "Unassigned" instead of none.
z
zaanton
02/12/2020, 4:57 PMThe field I am applying the filter on is Name.
a
Aria Ghahari
02/12/2020, 5:06 PMName is the name of the entity associated with the record which can't be left blank on transactions (transactions are entity / subsidiary based) How are you getting - None - in results? Can you please also share a screenshot of the results column? Please mask sensitive information,
z
zaanton
02/12/2020, 5:18 PMHere is a screen of the results, I have hidden all Customer names.
a
Aria Ghahari
02/12/2020, 5:22 PMThat's strange. Try using a formula in your criteria:
Aria Ghahari
02/12/2020, 5:23 PMformula (numeric)
CASE WHEN {name} IS NOT NULL THEN 1 ELSE O END
Then choose from filter:
Is 1
👍 3
z
zaanton
02/12/2020, 5:30 PMThat worked! The - None - field is no longer included in the results. Thank you so much for your help.
a
Aria Ghahari
02/12/2020, 5:30 PMNo problem. Glad it worked.
3 Views