I am trying to add a table to my document that sums all of the loan amounts for a given person and creates a field that contains that sum for each of the rows that is connected to that person. I'm trying to add it to my script but i keep getting an "invalid expression" error. This is what I have:
sum(amount) as personTotal
where Employee = 'Non Employee'
GROUP BY Person;
In the end I would like to have something that looks like this: