I resolve this by importing results of beanquery in pandas dataframe and doing all further manipulations there.
On Monday, October 20, 2025 at 9:26:45 AM UTC+2 Stefano Zacchiroli wrote: > 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/0db38d1a-64f7-477a-b3d4-d7f73b264d31n%40googlegroups.com.
