Re: [GNC] Check for negative amount in scheduled transaction formula
Hi Ron, Ron Stone writes: > 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? Yes, this file will be over-written at the next upgrade. Creating a new file would require you to get gnucash to load it.. IMHO, you should make the edits to fin.scm now, and then make a patch and submit to to Bugzilla for inclusion in future versions. > Ron -derek > - Original Message - > From: "Derek Atkins" > To: "gnucash dgr9z" > Cc: "Gnucash Users" > Sent: Monday, January 21, 2019 3:16:52 PM > Subject: Re: [GNC] Check for negative amount in scheduled transaction formula > > gnucash.dg...@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 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Check for negative amount in scheduled transaction formula
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" To: "gnucash dgr9z" Cc: "Gnucash Users" Sent: Monday, January 21, 2019 3:16:52 PM Subject: Re: [GNC] Check for negative amount in scheduled transaction formula gnucash.dg...@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 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Check for negative amount in scheduled transaction formula
gnucash.dg...@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 de...@ihtfp.com www.ihtfp.com Computer and Internet Security Consultant ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Check for negative amount in scheduled transaction formula
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? Many thanks, Ron ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.