* Martin Blais bl...@furius.ca [2014-10-31 19:02]:
BTW, it's worth noting that both of those features are special cases of
modifying aggregation keys.
The --pivot=payee case is equivalent to a SQL:
SELECT payee, account, sum(change) FROM ... WHERE account ~ liab GROUP
BY 1, 2;
Can your
Hi Eric,
I tried reproducing the problem you describe but cannot (I hit other
problems, but eventually get it working).
Can you provide a minimal example ledger file where it fails? (Just a
couple of transactions that highlight the problem.)
On Thu, Oct 30, 2014 at 8:39 PM, Eric Abrahamsen
Martin Blais bl...@furius.ca writes:
Hi Eric,
I tried reproducing the problem you describe but cannot (I hit other
problems, but eventually get it working).
Can you provide a minimal example ledger file where it fails? (Just a
couple of transactions that highlight the problem.)
Sure! I'm
* Eric Abrahamsen e...@ericabrahamsen.net [2014-10-31 14:05]:
ledger -f ~/.ledger/test.dat bal payable --pivot=payee
And get:
20 USD Liabilities:Payable:Magazine
-100 USD payee
-20 USDBob Jones:Liabilities:Payable:Magazine
-25 USDJane Doe:Liabilities:Payable:Magazine
-55
Martin Michlmayr t...@cyrius.com writes:
* Eric Abrahamsen e...@ericabrahamsen.net [2014-10-31 14:05]:
ledger -f ~/.ledger/test.dat bal payable --pivot=payee
And get:
20 USD Liabilities:Payable:Magazine
-100 USD payee
-20 USDBob Jones:Liabilities:Payable:Magazine
-25 USD
On Fri, Oct 31, 2014 at 5:05 PM, Eric Abrahamsen e...@ericabrahamsen.net
wrote:
Martin Blais bl...@furius.ca writes:
Hi Eric,
I tried reproducing the problem you describe but cannot (I hit other
problems, but eventually get it working).
Can you provide a minimal example ledger file
On Fri, Oct 31, 2014 at 5:14 PM, Martin Michlmayr t...@cyrius.com wrote:
* Eric Abrahamsen e...@ericabrahamsen.net [2014-10-31 14:05]:
ledger -f ~/.ledger/test.dat bal payable --pivot=payee
And get:
20 USD Liabilities:Payable:Magazine
-100 USD payee
-20 USDBob
When I want to see how much money I owe people, I do:
ledger bal liabilities:payable
And see an undifferentiated total.
When I want to see who I owe that money to (ie, the payees), I do:
ledger bal liabilities:payable --pivot=payee
Which gives me an output that seems to include all the people