* Martin Blais <[email protected]> [2018-04-22 17:31]: > You can achieve the same thing already with a group-by on the (account, > meta) pair: > > plugin "beancount.plugins.auto" > > 2018-04-22 * "Income from ABC" > customer: "ABC" > Assets:Bank 100.00 EUR > Income:Business:Hosting -100.00 EUR > > 2018-04-22 * "Income from CDE" > customer: "CDE" > Assets:Bank 150.00 EUR > Income:Business:Hosting -150.00 EUR > > > ;; bean-query > /home/blais/r/q/beancount-data/user/michlmayr/groupby.beancount > ;; "select account, entry_meta('customer'), sum(position) where account ~ > 'Income' group by 1, 2" > ;; account ent sum_positio > ;; ----------------------- --- ----------- > ;; Income:Business:Hosting ABC -100.00 EUR > ;; Income:Business:Hosting CDE -150.00 EUR
Given this example, is where a way to limit the query where sum(position) is < 125? -- 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 on the web visit https://groups.google.com/d/msgid/beancount/20191028145447.GA21153%40jirafa.cyrius.com.
