On Tuesday, January 29, 2019 at 3:43:55 PM UTC-6, Jason Chu wrote:
>
> 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.
>
> Ok, I think I see the logic in that. And that does work.
> 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.
>
Yeah I'm failing to think of a case where I would want to know how much my
PTO hours appreciated.
Thanks!
>
> On Mon, Jan 28, 2019 at 7:19 PM Jeff Brantley <jsb...@gmail.com
> <javascript:>> 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 beancount+...@googlegroups.com <javascript:>.
>> To post to this group, send email to bean...@googlegroups.com
>> <javascript:>.
>> 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 beancount+unsubscr...@googlegroups.com.
To post to this group, send email to beancount@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/beancount/1e808500-d6cc-4cff-86d1-e6b92573df65%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
