Formula Help

09/10/2014


From original questioner:

Looking for an expert as I am not. The following formulas work independently, I want to subtract the second one from the first but can't get the brackets right. Any help appreciated. TIA

[Select Sum(AcrInv.InvTtl) From AcrInv Where AcrInv.Status < 5 And AcrInv.InvTyp = 1 And AcrInv.JobNum = {ActRec.RecNum}]

[Select Sum(JobCst.CstAmt)from JobCst Where JobCst.Status =1 And JobCst.JobNum = {ActRec.RecNum}] *0.42 + [Select Sum(JobCst.CstAmt) from JobCst Where JobCst.Status =1 And JobCst.JobNum = {ActRec.RecNum}]

From contributor Ga


Tom,

What program are you trying to use this in?

From contributor To


The program is Sage 100 Contractor which is our accounting package. The Acrinv. are record numbers in the database.

From contributor Mi


check out the formula example at sage help website for an idea. This forum is a good place to find sage 100 experts.
Disclaimer, I am a nerd but not this particular flavor of Sage 100 nerd.