You can convert the position using something like this:
CONVERT(position, "EUR", date)
So the whole query would be:
select date, sum(CONVERT(position, "EUR", date)) where account ~ 'Expense'
group by date
* Alexander Lazarević <[email protected]> [2024-01-02 17:45]:
> I use something like this to get my daily expenses:
>
> select date, sum(position) where account ~ 'Expense' group by date
>
> This gives me something like this:
>
> 1986-01-01 2.33 EUR, 543.00 XYZ, 1697.00 UVW
>
> Is there a way to get the daily expense just in one currency?
>
> Viele Grüße,
> Alexander Lazarević
>
> --
> 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/CAMPYxd%3DYBZ1bJbBGojG97StFytAy6M9KEVHk_O8jdHYPq-cW_w%40mail.gmail.com.
--
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 view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/20240102144224.GA1600687%40jirafa.cyrius.com.
