Summary calculation

[ohucan2]

I need help with a summary calculation. I have a summary report for design jobs in progress that totals all the time and expenses to date, minus any invoices against that job. However, the developer of the form did not program it to subtract deposit invoices, which I need to do to be accurate. There are not many deposit invoices made, maybe 10% of jobs, and rarely are there two made against the same job, but I still need that function to have an accurate assessment. Here is calculation for the summary: If(Record Type Code = "B";Quantity;GetAsNumber(""))

What the best add the deposits to this summary?

I hope this is enough of an explanation; I know very little about Filemaker.

[jamesducker]

It's not clear what 'record type code' is.

If, say, "A" means deposit invoice and "B" means balance invoice, try

if(record type code = "A" or record type code = "B",quantity)

[the GetAsNumber("") bit on the end serves no purpose]