Dan, is it possible to get the result as in the 1st query, but using the *balance *?
account amount (EUR) Assets:Bank1 1000.0 Assets:Bank2 1000.0 On Sunday, June 2, 2024 at 12:36:23 AM UTC+2 [email protected] wrote: > On 01/06/24 21:27, Chary Chary wrote: > > I am still trying to find the way to calculate the net worth at a > > certain date using *balance *field (I am not sure it will give me any > > advantage) > > > > But somehow it does not quire work as I expect > > > > E.g. > > > > ledger_text = """ > > > > 2020-01-01 open Assets:Bank1 > > 2020-01-01 open Assets:Bank2 > > 2020-01-01 open Income:Salary > > > > 2020-01-01 * "Salary 1" > > Income:Salary > > Assets:Bank1 1000 EUR > > > > 2020-01-20 * "Salary 2" > > Income:Salary > > Assets:Bank2 1000 EUR > > > > 2021-01-20 * "Salary 3" > > Income:Salary > > Assets:Bank2 1000 EUR > > """ > > > > date_iso = datetime.date(2020,12,31).isoformat() > > > > query=f""" > > select account, SUM(position) as amount > > where date <= {date_iso}AND account ~ 'Assets|Liabilities' > > """ > > > > result: > > > > account amount (EUR) > > Assets:Bank1 1000.0 > > Assets:Bank2 1000.0 > > > > > > This is correct!! > > Now using balance field > > query=f""" > > select account, LAST(balance) as amount > > where date <= {date_iso}AND account ~ 'Assets|Liabilities' > > """ > > account amount (EUR) > > Assets:Bank1 1000.0 > > Assets:Bank2 2000.0 <==== This is incorrect! > > So, what am I doing wrong? > > AFAICT, both queries do what they are expected to do. > > 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/b63fb46e-762c-4e06-8321-71f85aa4960en%40googlegroups.com.
