Edit: I started with this query:
SELECT date, account, other_accounts, position WHERE account ~ "Assets:Cash:Checking" which outputs more or less a journal, but I'd like to summarize it per other_accounts. I also tried to use SELECT account, other_accounts, position WHERE account ~ "Assets:Barvermögen:Giro:DKB" group by other_accounts But this yields the error > Received invalid data as query error. *(As all transactions from checking to any other account do only have one posting, there should be no problems regarding other_accounts holding potentially multiple postings/accounts.)* Peter schrieb am Samstag, 19. November 2022 um 10:12:50 UTC+1: > 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/3dc2d327-eb0f-44f3-902e-a15a7b3de106n%40googlegroups.com.
