Summing values from multiple tables in different notes

Things I have tried

  • Advanced tables and summing values in one table, check.
  • Dataview and using fields to create queries and returning data, check

What I’m trying to do

I have a Folder called Library. In this folder are Notes for individual authors I have in my book collection, and each note has a table of books I own by each author and an approximate value field. I currently use advanced tables to sum the values of the books in each author’s table. I’m looking to be able to query all of the notes in the folder Library, grab each note’s table’s sum, and then sum them all together. Advanced tables doesn’t yet support string concatenation, so i can’t have an advanced tables formula output ‘Sum:: ’ that dataview likely could use as a field in a query. Thanks for any input.

CB