:
> On 11/03/23 20:27, Daniel González wrote:
> > Hi,
> > I'm generating an income statement (with only my expenses) like this:
> >
> > SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON
> > 2023-03-30 WHERE account ~ "Expenses"
Hi,
I'm generating an income statement (with only my expenses) like this:
SELECT account, sum(position) FROM OPEN ON 2023-03-01 CLOSE ON 2023-03-30
WHERE account ~ "Expenses" GROUP BY 1 ORDER BY 1
But I have some subdivisions of my accounts that I would like to report one
level up.
For example
gt; 2022-10-03,Gas WF,Expenses:Gas,Assets:WellsFargo:Checking,40,USD
>
> But if you have more complicated transactions with multiple expenses,
> you'll also potentially end up with rows with multiple accounts like this:
>
>
> 2022-07-26,GasAndEat,Expenses:Gas
Hi,
I'm interested in querying an account for transactions made agains another
account in particular.
For example let's say I have:
2022-10-01 * "Gas bofa"
Assets:BofA:Checking
Expenses:Gas 40 USD
2022-10-02 * "Gas WF"
Assets:WellsFargo:Checking
Expenses:Gas 20 USD
