Wow, I swear I've asked this AND seen it answered, but can't find it.
I've created a junction field that contains the sponsor name and a single select field for the year: 
On the table where the sponsors originate, I want to show the MAX year. I've tried lookup and rollup and various suggestions from the forum, but I always get "0." Here's the current set up, based on a suggestion from @kuovonne in a previous thread. Instead of a rollup field, I have a lookup, then a formula to output MAX.
The lookup is great, but you can see the formula always shows "0." The formula I'm using is
MAX(ARRAYUNIQUE(ARRAYFLATTEN({years Rollup (from junction table)})), ", ")
I've also tried a rollup field:
- Using MAX(Values) gives an error.
- Using ARRAYJOIN(values) gives a list of the numbers, but the forula field still shows 0.
I know I'm missing something obvious, but can't figure out what it is. Thanks!!
