This is a pre-built calculated field already in Sage.  You just have to add the cost code detail

[Select Sum(BdgLin.TtlBdg) From BdgLin Where BdgLin.RecNum = {ActRec.RecNum}] + [Select Sum(PrmChg.CstAmt) From PrmChg Where PrmChg.Status = 1 and PrmChg.JobNum = {ActRec.RecNum}]

Char - Can you please tell me what I'm doing wrong in order to have the Budget calculate correctly by adding the Change Order Budget to the Original Budget to get my report to come out?

Right now it is pulling the original budget totals plus change order budget totals, NOT per cost code.  It looks like it probably needs an inner join formula.  Do you have a Sage Consultant?  I'm not great at inner joins, but Pam Schulz or Walt Matheison are.  You will need to contact one of them to modify your report for you for a fee.  Sorry.  You can email me directly and I could forward to them.

Right now it is pulling the original budget totals plus change order budget totals, NOT per cost code.  It looks like it probably needs an inner join formula.  Do you have a Sage Consultant?  I'm not great at inner joins, but Pam Schulz or Walt Matheison are.  You will need to contact one of them to modify your report for you for a fee.  Sorry.  You can email me directly and I could forward to them.

Thank you for your help.

Hi Cindy L, if the above suggested answer helped, please do mark it as verified  (by clicking the "more" button) for the benefit of others in this forum :). Thank you!

If you have a minute, tell us about your great experience on Sage City, take this short 3 question survey