I approve of this message
On Tue, Oct 21, 2025 at 6:50 AM Chary Ev2geny <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/beancount/0db38d1a-64f7-477a-b3d4-d7f73b264d31n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAK21%2BhPAfRP3FTaOhCYxKpcfNUz2L%2B10em6AQKSCo44wC11q-w%40mail.gmail.com.
