Ah yes...
On Sun, Oct 19, 2025 at 11:45 PM Martin Michlmayr <[email protected]> wrote: > Doesn't work with "GROUP BY": > > beanquery.compiler.CompilationError: all non-aggregates must be covered by > GROUP-BY clause in aggregate query: the following targets are missing: > "balance" > > That's why I'm asking; or maybe that's a bug I should report. > Daniele? > > * Martin Blais <[email protected]> [2025-10-19 23:42]: > > Special column named "balance" > > > > > > > > On Sun, Oct 19, 2025 at 10:29 PM Martin Michlmayr <[email protected]> > 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. > > > > > > -- > > > Martin Michlmayr > > > https://www.cyrius.com/ > > > > > > -- > > > 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/20251020022907.GA2661113%40panya.cyrius.com > > > . > > > > > > > -- > > 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%2BhMcdg49147ix5Z7zZV0MQmMYM5tFM4SM6OPEc2cDGg%3Dew%40mail.gmail.com > . > > -- > Martin Michlmayr > https://www.cyrius.com/ > > -- > 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/20251020034454.GA2665429%40panya.cyrius.com > . > -- 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%2BhPTkc23gR3f1fdHA4kw6zy8H5M5-H0uTVdOKWgYtnFONQ%40mail.gmail.com.
