Pull & update: https://bitbucket.org/blais/beancount/commits/c5057262f77d7b16fa2250b22f115e9ecee26754
bean-query $L 'select truncate(account, 3), convert(cost(sum(position)), "USD") group by 1 order by 1' Also note the existence of the PARENT(), LEAF() and ROOT() functions to act on account name strings. Moreover, if you have mixed assets, you will want to convert or extract the cost in order to view output that's manageable. On Tue, Sep 18, 2018 at 10:29 AM Vikas Rawal <[email protected]> wrote: > I would like create a trial balance report with accounts truncated to a > specific depth (say, two levels). > > How could I modify the following trial balance query to achieve this? > > SELECT account, sum(position) > GROUP BY account > ORDER BY account; > > > Vikas > > -- > 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/CALtzAB280FQqE20Pdkoj%2B7FTa0GCXy8JfDuxmvaNS0Z7ExNGsA%40mail.gmail.com > <https://groups.google.com/d/msgid/beancount/CALtzAB280FQqE20Pdkoj%2B7FTa0GCXy8JfDuxmvaNS0Z7ExNGsA%40mail.gmail.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%2BhPk%3DaK3HgJaqVH4vj0kev2jyo0BBsLXVSCfg9pXaMvJpA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
