Forum Discussion
Lookupvalue from Grouped Table want to return Aggregate Value
I have a large table of all my schedule updates. Each monthly schedule update contains the same schedule activity so the table has multiple times rows of the same activity (20 or more as i add updates).
What im trying to do is add a column that has the Min Finish Date for and Activity ID so i can calculate a variance for each update . I though the best way to do this was to make a grouped table by Activity ID add the column with the Min Finish Date aggregate. But when i go to do a lookupvalue in the original table i get an error "! A table of multiple values was supplied where a single value was expected."
How do i get aroud this? Is there a beter method to achive the same result?
Original Table 200,000 plus rowsGrouped Table 13,000 rows
9 Replies
- healthEteam
Resolver I
Did you create the relationship on activity id between the two tables?
If so I would think you could use the Related function to retrieve the columns from aggregate table into the original.
