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!