Skip to main content
Question

Map items of List to Dimension when info is missing

  • November 26, 2025
  • 1 reply
  • 9 views
J
Apprentice Author

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

1 reply

Min Li
Master Helper
Forum|alt.badge.img+12
  • Min LiMaster Helper
  • Master Helper
  • November 30, 2025

You can add a new item called ‘Undefined’ to the sales_team dimension. Then, in the transaction list, create a new dimension column for Sales_team and map blanks to ‘Undefined’ using:

ifblank(Transaction.'Sales_team', Sales_team."Undefined")

Finally, update your formulas to reference this newly created column.

Min Li

Ask your question here!

Terms & ConditionsCookie settingsAccessibility statement