I’m trying to get a ref value from another table for my report template.
Slice (used to build the report - I’m slicing only the values that we need: weekly classes given)
Trainer (Table with the info of our trainers)
My first expressions get all the records from the slice:
**<<Start:SELECT(Recent Sessions[sessionID], TRUE)>>**
The second expression tries to get the list of trainer records that match the current trainer ID
**<<Start:SELECT([Trainer][trainerID], ([trainerID] = [_THISROW].[trainerID]), TRUE)>>**
However I’m getting the following error:
Expression ‘SELECT([Trainer][trainerID], ([trainerID] = [_THISROW].[trainerID]), TRUE)’ is invalid due to: Unable to find column ‘Trainer’, did you mean ‘trainerID’?. Error: Report ‘Last Week Session Report’ action ‘Email Managers’ Body template. Start expression ‘SELECT([Trainer][trainerID], ([trainerID] = [_THISROW].[trainerID]), TRUE)’ should generate a List of Ref values.
I followed this topic:
However OP didn’t post what worked for her.
Any idea what the expression might be missing?
Update: Report config view