Hi all! I have a reference table (REFERENCE) in which I keep all of the values (THEME) for a tagging system in my main database (MAIN). I would like to return averages into my reference table of the performance data of all entries in MAIN that have the corresponding tag.
The tables are related, as MAIN pulls in the tag values from REFERENCE for the drop-down multi-select.
The problem is that you are filtering the STATISTIC column instead of the whole MAIN database. Also you can combine the two filters into one. Try this instead:
[MAIN].filter(
[MAIN].[THEME].Contains(thisRow.[THEME])
AND [MAIN].[STATISTIC]>0
).[STATISTIC].Average()
Thanks. It’s still not returning any values for fields in which the rows in [main] have more than one [theme] are selected. Those are just blank. And for those it is returning, it’s the average of the unfiltered column. Any ideas?