Jump to content

Summary calculation


This topic is 5689 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

This topic is 5689 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.