[GNC] Check for negative amount in scheduled transaction formula

Ron Stone ronstone at ncf.ca
Tue Jan 22 06:49:18 EST 2019


Thanks for this Derek. I'm on a Mac and only see one copy of fin.scm in the application bundle. Seems any edits to this would be lost at the next upgrade. Should I be defining another one somewhere under ~/Library/Application Support/GnuCash or elsewhere?

Ron

----- Original Message -----
From: "Derek Atkins" <derek at ihtfp.com>
To: "gnucash dgr9z" <gnucash.dgr9z at ncf.ca>
Cc: "Gnucash Users" <gnucash-user at gnucash.org>
Sent: Monday, January 21, 2019 3:16:52 PM
Subject: Re: [GNC] Check for negative amount in scheduled transaction formula

gnucash.dgr9z at ncf.ca writes:

> Hi,
>
> Is it possible to convert negative numbers to 0 in a formula? something like:
> a-b < 0 ? 0 : a-b
>
> If this needs to be defined as a function someplace, what would it
> look like, where would it go, and how would it be called from the
> template?

Look at fin.scm and copy the functions in there.

> Many thanks,
> Ron 

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins                 617-623-3745
       derek at ihtfp.com             www.ihtfp.com
       Computer and Internet Security Consultant


More information about the gnucash-user mailing list