Hey All, I need help. I have a contact saved searc...
# suiteanalyticsv
Vikas
07/09/2020, 1:36 AMHey All, I need help. I have a contact saved search where if I add a column “Billing Address : Internal ID”, it hides all the contacts from results which has no billing address saved. My requirement is to show all contacts in result and if the value is blank in “Billing Address : Internal ID” field, it should show empty. I tried formula text, but no luck.
a
al3xicon
07/09/2020, 12:46 PMI had to solve this recently, one sec
al3xicon
07/09/2020, 12:52 PMCASE WHEN {address.isdefaultbilling} = 'T' THEN TO_CHAR({address.addressinternalid}) ELSE ' ' END
al3xicon
07/09/2020, 12:52 PMthat should give you the billing address Id whether there is one or not for the customer
v
Vikas
07/13/2020, 10:10 AMThanks for your response @al3xicon but it did not work. I tried on contact and customer searches both. Is this working for you? Am I doing anything wrong or missing any configuration settings?
a
al3xicon
07/13/2020, 12:59 PMi'm not sure, it worked for me