On Mon, Oct 20, 2025 at 10:29:07AM +0800, Martin Michlmayr wrote: > I used the following query to see what I spent on a recent trip: > > SELECT account, SUM(CONVERT(position, 'USD', date)) WHERE account ~ > "Expenses:" AND 'something' in links GROUP BY 1 ORDER BY 1 > > I'd like to have a third column that shows the running total of column > two but I can't figure out how.
I never found a way either. My common workaround is to have two queries, one with the details like yours and one with the grand total at the end. (And it is indeed a limited workaround, as it only shows you the final total.) Cheers -- Stefano Zacchiroli - https://upsilon.cc/zack Full professor of Computer Science, Polytechnic Institute of Paris Co-founder & CSO Software Heritage -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/beancount/jzf3h2vb4prxqaldg2nifw4zzmvwuau3ng7wnmhf3g6gnqxndk%40gh74agrzmtx6.
