Patrick, thanks for the answer, but I am afraid I do not have enough knowledge to understand your answer.
What you shave show is not a bean-query language, this looks time elements of python code Can you in this case give me some broader and complete source of code and I will try to get my head around Regards. On Sunday, November 29, 2020 at 4:58:33 PM UTC+1 [email protected] wrote: > Hi, > > Do you have different currencies? Here is a (complex) example that I run > to value and convert with a specific year. > > number(only("CHF", convert(sum(value(position, #"2020-12-31")), "CHF", > #"2020-12-31"))) > > Let's deconstruct that from the inner parts > > sum(value(position, #"2020-12-31")) > this sums up the value of a position (using prices from 2020-12-31) > > convert(..., "CHF", #"2020-12-31") > convert everything to CHF with FX as of 2020-12-31 > > number(only("CHF", ...)) > Now take only the CHF out of this (as everything was converted to CHF, > this is actually only CHF)) and then take the number > > > If you don't have different currencies or prices involved it becomes a lot > simpler and you can drop those parts. > > > Regards, > > Patrick > > > On 29.11.2020 16:50, Chary Chary wrote: > > Hi, everybody > > is there a way to get a single number report with bean-query > > e.g. I want all Expenses for all the period in one number. > > The maximum I got so far is listing all expense accounts and their > balance. To to get a total expenses I would have to dump it all in Excel > and sum there. > > So, I want something like > > SUM(COST(position)) WHERE account ~'Expenses' > > But this does not work > > Regards. > > -- > 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/31497363-986a-4745-a202-526236c532d8n%40googlegroups.com > > <https://groups.google.com/d/msgid/beancount/31497363-986a-4745-a202-526236c532d8n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > -- 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/3ca0d4b1-d0ad-4d8c-be56-01a449ec4c90n%40googlegroups.com.
