Hello,
I didn’t find the solution on the community, so here I am!
I converted a select list into a table, and I want to know the average rating for each row in this new table (in other words, for each item of the initial selected list). In the original table, each row has a rating. Here is a dummy doc to illustrate the situation : https://coda.io/d/Books_dnmspB5GOle
I tried several formulas and the “best” result I have so far is the exact same average rating for every row in my new table. Which is not correct. I used this formula : Books.Filter(Categories.Contains(thisRow.Categories)).Average(Books.Rating)
Thank you for your help 