I'd like to fetch the sum (per account) of the amount of money I sent from my checking account to any account during the year. The goal is to compute the average outflow per month to get a better understanding of the cashflow.
I tired: SELECT account, other_accounts, sum(units(position)) WHERE account ~ "Assets:Cash:Checking" group by account, other_accounts or SELECT account, other_accounts, units(sum(position)) WHERE account ~ "Assets:Cash:Checking" group by account, other_accounts and variations of that. Each query failed by telling me > TypeError: unhashable type: 'list' I guess, there's a problem calculating a hash or so, but I don't know. Tried to search in this group, but I didn't find anything related that helped (I'm pretty sure I used the wrong search term, tbh). How do I get the summarized outflow from the checking account to any other account using bean-query? -- 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/ec5b7887-63d9-49a3-80f7-5ee317013db6n%40googlegroups.com.
