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ć <alexan...@lazarevic.de> [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 beancount+unsubscr...@googlegroups.com. > 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 beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/20240102144224.GA1600687%40jirafa.cyrius.com.