AnsweredAssumed Answered

Trailing Grand Summary and a summary field

Question asked by LarryMastromatteo on Aug 15, 2011
Latest reply on Aug 18, 2011 by LarryMastromatteo


Trailing Grand Summary and a summary field


I have a work on hand table in my invoice database that I am trying to put a summary field that will add up all of the invoices and subtract them against the contract amount to give a total of work on hand. But when I try to put the summary field in the grand summary part it does not add the invoices properly. So, for example,  on a contract I invoiced $1,000 - 3 times it gives back a result of $9000. What am I doing wrong? Any help would be appreciated! Thank you!