holroy
August 28, 2023, 7:48pm
2
I would switch to dataviewjs , and add another row with the calculated sum. This has been addressed in various posts recently, and below is one of my earlier answers:
My main approach to such an issue is to switch to dataviewjs, and do the extra work on the table within the javascript code there. So here is one attempt on doing this:
## Original query
```dataview
TABLE WITHOUT ID
file.link as Account, Amount, Payment_rate
WHERE file.folder = this.file.folder
WHERE number(Amount)
```
## With summation
```dataviewjs
const amounts = await dv.query(`
TABLE WITHOUT ID
file.link as Account, Amount, Payment_rate
WHERE file.folder = this.file.folder
WHERE n…