Thank you Dan for the insights, I will continue using single queries without any issues. Thanks for the help!
Andrea Il giorno martedì 5 marzo 2024 alle 00:22:14 UTC+1 [email protected] ha scritto: > On 03/03/24 23:16, Andrea Vidali wrote: > > > Which outputs multiple balances for each line > > You have one balance per row, as expected. However, each balance > contains amounts in different commodities, presented separated by a comma. > > The `balance` column in beanquery is just the cumulative sums of all the > positions iterated by the query. It does not obey the GROUP BY clause. > > Adding the possibility to compute what you ask is on the todo list, but > it is not trivial. One of the issues it that the SQL-like syntax for > such a query is quite complex (actually, I cannot even come up with a > SQL query that does exactly what you would like, without involving one > subquery, if someone know a better way I'll be happy to see it). > > Cheers, > Dan > > -- 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/a3aa4184-e9c1-4e69-bcf5-a6dde53d6bacn%40googlegroups.com.
