Balance Filter

[lipp f]

I would like to include in a ballance result only accounts where current balance is above 100CAD.

tryed:

• bal  'expr abs(quantity) > 100CAD' --real
• bal --amount --real --value-expr 'if(abs(quantity) > 100CAD, amount, null)'
• bal --limit 'amount > 100CAD'

and none of them seems to produce a correct result

Any ideea?

[david whiting]

Does this work for you?

bal --limit 'display_total > 100'  -X CAD

David

--

---
You received this message because you are subscribed to the Google Groups "Ledger" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ledger-cli+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/ledger-cli/76849151-7a6b-415a-bd56-097c93132e1dn%40googlegroups.com.

--

David Whiting

[david whiting]

I'm getting some weird results with this depending on what value I use for the total, so this probably doesn't do what you need.

David

--

David Whiting

[lipp f]

not working for me either. Includes all possible accounts and gives me a balance of CAD 20,350,323.46 and it should be about  CAD 710,000

[John Wiegley]

>>>>> "dw" == david whiting <david.r...@gmail.com> writes:

dw> Does this work for you?
dw> bal --limit 'display_total > 100'  -X CAD

I think you might want ‘--display’.

‘--limit’ filters which items are computed as part of the totals, while
‘--display‘ filters which items are shown. They can also be used together.

John