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] )
It does appear there are duplicate values in the field_value_id column as there are 7,444 rows but only 6,315 distinct values.
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
That worked when I changed it to
MAXX (RELATEDTABLE ( field_value_choices ), field_value_choices[field_choice_id] )