I just encountered a query on how to set the field “Customer Category” not to select any values from the list but to None while creating a saved search.
Option 1
Was to set in the criteria tab “Customer Category” is None
Option 2
Is to set the formula {Custtype} IS NULL
The formula used here is
((SUM(CASE WHEN {account}=’41000 SALES REVENUE : Product Sales’ AND {custtype} is NULL THEN {amount} ELSE 0 END))-(SUM(CASE WHEN {account}=’51000 COST OF SALES : Product Cost’ AND {custtype} is NULL THEN {amount} ELSE 0 END)))/NULLIF(SUM(CASE WHEN {account}=’41000 SALES REVENUE : Product Sales’ THEN {amount} ELSE 0 END),0)
This can be done