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.
