I have 2 databases: 1) a Project profile(contains project specific information ) and, 2) a budgeting database (tracks all invoices)

I need to be able to show dollar totals on the "project profile" database by department.

The buget database has a department field to differentiate the records and i have a relationship tied to project total. I cannot seem to get dollars seperated by department. i am lookig for a "Sum If" like command.

Thanks!

Are you finilar with FMP's Summary layouts?

Create a new layout. Delete the "body" and create a Sub-Summary part with "department" as the sort (break) field. Make a summary field in the database that is the total of the dollars.

Sort the database by Department and Preview the summary layout.