Thank you. It looks like I need to write a script to do this instead of searching for a BQL recipe.
On Friday, January 21, 2022 at 1:38:10 AM UTC-8 redst...@gmail.com wrote: > 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 beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/dfbab351-b922-4959-b487-865e9b52fdden%40googlegroups.com.
