Hello,
I have a transaction list per customer_id with information regarding sales_team. However some clients are not properly mapped and do not have any data inside the “sales_team” column.
When i retrieve the data from this transaction list via [BY : sales_team] i lose all clients that are missing the info.
How could i include in my formula a way to have all customers not mapped under “blank” sales team ? I could add a formula directly into my transaction list but as i do have 6M lines i’m afraid it’ll trigger performance issue.
Thanks in advance