Get Sum of a Row from multiple files

[EricSturm]

I have a file for each session I run (TT RPG). For each session the party gets XP. I want to get the sum of all XP from all session as one value displayed. I am sorry if that was already solved but I couldn’t find something similar with the help.

Current attempt:

TABLE sum(XP_Party) AS "XP Party"
FROM "0. Player Party/10. Sessions"

Output from current attempt:

File | XP Party
Session 1 | 250
Session 2 | 300

Expected/Wanted result:

XP Party
550

If possible I would later on expand this with the total xp for each player.

[mnvwvnm]

If you want a table… Try this:

TABLE WITHOUT ID sum(rows.XP_Party) as "XP Party"
FROM "0. Player Party/10. Sessions"
WHERE XP_Party
GROUP BY true

[EricSturm]

@mnvwvnm

TABLE WITHOUT ID sum(rows.XP_Party) as "XP Party"
FROM "0. Player Party/10. Sessions"
WHERE XP_Party
GROUP BY true

That worked, thank you very much!