On Wed, Sep 28, 2016 at 2:22 PM, <[email protected]> wrote: > Hi > > I am starting with Beancount and plaintext accounting in general so, > please, forgive me if I am asking a silly question. > > I've generated an example beancount file proceeded to issue various > commands within bean-report. > > For example if I generate balance report I see this > bean-report ~/example.beancount bal > ..... > Expenses:Financial:Commissions 331.15 USD > Expenses:Financial:Fees 132.00 USD > Expenses:Food:Alcohol 25.43 USD > Expenses:Food:Coffee 87.25 USD > Expenses:Food:Groceries 6613.79 USD > Expenses:Food:Restaurant 12494.94 USD > Expenses:Health:Dental:Insurance 205.90 USD > Expenses:Health:Life:GroupTermLife 1726.72 USD > Expenses:Health:Medical:Insurance 1943.98 USD > Expenses:Health:Vision:Insurance 3003.30 USD > Expenses:Home:Electricity 2080.00 USD > Expenses:Home:Internet 2560.75 USD > Expenses:Home:Phone 1942.67 USD > Expenses:Home:Rent 76800.00 USD > .... > > Is there a way to display aggregate balances on "parent" accounts like > Expenses:Home and Expenses:Food (they don't exist in the file, but I can > open them any time)? Is it even possible? >
> If it is not possible within bean-report I am ok with bean-query, but I > need a hint on this. > You can do something like this with bean-query: bergamot:~$ bean-query $L 'select parent(account), units(sum(position)) group by 1 order by 1' It's not perfect, because this will remove exactly one level of account. Ideally one might want some other scheme, e.g. "max depth 2 levels". I could easily provide a function like that, or some other ones. Let me know what you think would be useful. The SQL shell is an evolving beast and a bit of a prototype, in use so we can find what people use most, and to find out if it can replace the custom reports entirely (I think it can). For that reason, it's the one area where I'm super liberal about adding new stuff. > > Thanks. > > -- > 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 post to this group, send email to [email protected]. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/beancount/ca2ca60e-7749-4a9a-a465-caa4c4b33935%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/ca2ca60e-7749-4a9a-a465-caa4c4b33935%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNgj0JddkqBuoBfcLVk74m%2Bfzzm0fuEPTni7dfGJy6%2BUA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
