anyone got any clue why including "Billing Address...
# suiteanalytics
b
anyone got any clue why including "Billing Address : Internal ID" result column in a vendor search acts as a filter ? It removes any vendors which haven't got a "Billing Address". I've even tried to add the column as a formula ( case when {billaddress} is NULL then '' else {billingaddress.internalid} end ) and it still filters my results to vendors which have a "Billing Address"
g
I believe it has to do with the type of join that happens in saved searches. It looks for records that have matches in both tables, so you'll only get Vendors with billing addresses internal IDs.
k
Odd, I've never had that behavior before
Adding results has never worked like a filter for me
are you sure you don't have some kind of criteria on address?