bean-query Absolute value on inventory?

[Jacques Gagnon]

Hi,

I got a simple report with bean-query for taxable interest and filter on the Income account so the amount is negative.

I though I could use the absolute function to get ride of the sign but it doesn't work:

select year, abs(sum(position)) as interest where account ~ "Income:Interest" and not account ~ "TFSA|RRSP" group by year order by year

ERROR: Invalid type for argument 0 of Abs: found <class 'beancount.core.inventory.Inventory'> expected <class 'decimal.Decimal'>.

Any suggestion? It's not a big deal but I'm still curious.

[Martin Blais]

Only defined over Decimal:

https://bitbucket.org/blais/beancount/src/tip/beancount/query/query_env.py?fileviewer=file-view-default#query_env.py-33

It would be next to nothing to add it for Inventory and Position

--
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+unsubscribe@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAPgTVrbPfjV05o7oWgtR-114ApSDy-znAKF1wqo-yjKOS%3Dt8Lg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[Martin Blais]

https://bitbucket.org/blais/beancount/commits/ad9918769be6404b5e0452a7f2d36dba1866ddd4

[Jacques Gagnon]

That work, Thanks :)

Jacques Gagnon
GTalk/E-Mail: darth...@gmail.com
WLM (MSN): clou...@msn.com

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhM3Wt36XebPSvU5WoRCDHa4jicWGiUUU%3DYUxZNQ3j27OA%40mail.gmail.com.