* Jonathan Salles <[email protected]> [2019-04-19 16:56]:
> This query gives the results below:
> SELECT
> account,
> position,
> balance
This will show the correct result:
select account, sum(position) WHERE account ~ 'bank' GROUP by 1
account sum_positio
----------------------------- -----------
Assets:US:Bankspouse:Checking -400.00 USD
Assets:US:Bankself:Checking -200.00 USD
> WHERE any_meta('retirement') ~ "2018RothIRA"
> AND account ~ "bank"
> ORDER BY account
>
> account position balance
> -----------------------------------------
> bank_spouse 100.00 USD 100.00 USD
> bank_spouse 100.00 USD 300.00 USD
> bank_spouse 100.00 USD 500.00 USD
> bank_spouse 100.00 USD 700.00 USD
> bank_spouse 100.00 USD 900.00 USD
> bank_self 100.00 USD 200.00 USD
> bank_self 100.00 USD 400.00 USD
...
Unfortunately I don't know how to show the individual positions and
the balance.
--
Martin Michlmayr
https://www.cyrius.com/
--
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/20190420053831.GB15522%40jirafa.cyrius.com.
For more options, visit https://groups.google.com/d/optout.
