Skip to main content
Question

duplicate results in a Formula - Multi-select Text field

  • September 13, 2022
  • 0 replies
  • 104 views
I am getting duplicate results in a Formula - Multi-select Text field.  It looks like this:


My formula and settings look like this: 


Can anyone tell me how to eliminate the duplicate Air District results within each record? For example, for Customer #106, I only need it to show "South Coast" once, not three times.  I know it's doing this because that Customer has 3 records in the Facilities table and they are all in South Coast. 

I am really new at this so I couldn't make sense of the answer in a similar post.
Thanks!​

------------------------------
Jennifer Colomb
------------------------------
      This topic has been closed for replies.

      TammieKing
      Forum|alt.badge.img+10
      Can you roll these up to the parent table with a Summary(Combined Text) in the relationship then bring that new field back down if you need it in the Child Record?

      ------------------------------
      Tammie King
      ------------------------------
      Terms & ConditionsAccessibility statement