[GNC] Omission from help manual: formulas

David T. sunfish62 at yahoo.com
Mon Sep 17 11:34:56 EDT 2018



> On Sep 17, 2018, at 11:29 AM, Adrien Monteleone <adrien.monteleone at lusfiber.net> wrote:
> 
> David & Stan,
> 
> From my experimentation, I think your descriptions are correct.
> 
> Exponents aren’t supported. (yet)

Since the email explanations date from 2005, I don’t think this will be added any time soon.

> 
> All formulas must be simple, but nesting/precedence parenthesis are allowed.
> 
> While you can’t calculate using other splits or transactions as references/variables, you *can* use variables.
> 
> For example, while in a discussion a few months ago on envelope budgeting, I decided to set up an SX to allocate my pay to my envelopes based on the percentages I chose for each. (this was still a very simple exercise since there was no way to ‘cap’ the allocation and have the excess flow elsewhere)
> 
> I set my Cash split in the SX template to ‘received * 1’
> Then I set each envelope split to ‘received *’ the percentage I wanted to allocate there. (each ‘envelope’ was a subaccount of ‘envelopes’ which was a current asset account)

This mirrors the examples in the wiki.

David



More information about the gnucash-user mailing list