My Enum field is having one incorrect option

Hi Team!

I know the subject line is kinda obscure so I will give a quick context:

  1. My app has an Enum field called New Group and this has 4 different options from which Agribusiness is one of those.
  2. It also has an Enum field called New Department that contains options based on New Group. So when a user chooses Agribusiness, the values in this field changes to departments that belong under Agribusiness Group.

Here's my concern:

All options from Field 2 are correct except HR Learning & Development that belongs to another Group.

ur_Jim_buddy_0-1728455143634.png

Here's the mapping of my table:

ur_Jim_buddy_1-1728455199589.png

Here's the formula for New Department:

 

Select(Key to Group[Department],([Group]=[_THISROW].[New Group]))

 

I am wondering why that one department, that shouldn't be there, is appearing in the New Department field's options.

Any help would be much appreciated.

Thanks!

0 10 246
10 REPLIES 10
Top Labels in this Space