Forum Discussion
Solved
LOOKUPVALUE error
I am getting the "A table of mulitpule values was supplied were a single value was expceted." I am trying to look up the field_value_choices[field_choice_id] based on the field_values[id] This form...
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
so basically what I am trying to have show in the Employee type column is - this is the field_values table
take the id 89088567
look on the field_value_choices table - match the id to teh field_value_id and return teh field_choice_id - 160597
But the field value choices table is the many side which means that for some ID's (at least one) you have multiple matches. Otherwise, the relationship would be one to one not one to many. And this is the source of the error in your formula. It could be blanks that is causing the issue. You need to double check your source data