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/4a667c45-070a-4153-8574-ccc7184e62f0%40grinta.net.
