Because it's a commodity and not at cost, I believe you want to use CONVERT(SUM(position), 'USD') instead of VALUE() because it doesn't have a market value, but it does have a conversion rate on a particular day.
I would say this is correct because you don't care what the value of the thing (vacation hour) was when you got it, all you care about is how much it is worth today. On Mon, Jan 28, 2019 at 7:19 PM Jeff Brantley <[email protected]> wrote: > By the way, I did try inserting a pricing directive for my VACHR, but it > won't show USD when I use the VALUE function in a query. From what I can > tell, VALUE only does something if the commodity is held at cost. > > I.e., if I book an Income/Assets pair transferring 8 VACHR, I still see > VACHR in the query results, but if I book the pair as 8 VACHR {30.00 USD}, > then I get USD reported (based on newest price directive) for the portions > held at cost, and VACHR reported for those with no cost attached. > > Is this expected behavior? > > -- > 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/05b296d2-781b-4598-9c44-1684b8502e60%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/05b296d2-781b-4598-9c44-1684b8502e60%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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/CAFFHUgsBOq3%2BmzGSez%3DZZiWhyeSL_j6J7iH7_NA1YXPChDrmVQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
