No way to currently do it AFAIK. A HAVING clause <https://github.com/beancount/beancount/issues/114> is on the wish list. See this comment <https://github.com/beancount/beancount/issues/114#issuecomment-632815268>.
On Thursday, January 20, 2022 at 9:51:06 PM UTC-8 Maayaas wrote: > Hi, > > I am using the query below to get a list of outstanding payments: > > SELECT > last(date), leaf(account), sum(position) as outstanding > WHERE > account ~ "AccountsReceivable" > GROUP BY leaf(account) > ORDER BY outstanding DESC > > It works as intended but it also lists the zero balance accounts. Is there > a way to exclude them? > > Thanks. > -- 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 on the web visit https://groups.google.com/d/msgid/beancount/4c37598c-cd96-4121-9554-86a531711d01n%40googlegroups.com.
