Re: Exclude empty amounts with GROUP BY

This would need a filtering expression of the aggregate, it's not implemented. SQL defines a syntax thought. On Mon, Mar 16, 2020, 04:19 Martin Michlmayr wrote: > I want to see a list of outstanding invoices. Given the example > below, I can use: > > beancount> SELECT ENTRY_META('invoice'),

Exclude empty amounts with GROUP BY

I want to see a list of outstanding invoices. Given the example below, I can use: beancount> SELECT ENTRY_META('invoice'), SUM(position) WHERE account ~ '^Assets:Receivable' GROUP BY ENTRY_META('invoice') ent sum_posit --- - A01 B01 30.00 USD Is there a way to exclude