troubleshooting Question

Complex Summary Calculation in Filemaker Pro 11 Advanced

Avatar of kwheil
kwheilFlag for United States of America asked on
FileMaker ProWindows 7
10 Comments1 Solution982 ViewsLast Modified:
I am trying to include a summary calculation for costs on a report by fiscal year and building for a construction project. The database stores the information in four tables: Fiscal Year, Buildings, Projects, and Tasks. The Fiscal Year table is linked to the Projects table by FY and includes calculated summaries for each project year. The Building table is linked to the Tasks table by building. The Tasks table is linked to the Projects table by project number.

My problem occurs due to the costs being separated into design costs and construction costs in the Projects table with each having a different fiscal year. Thus to summarize a single fiscal year by building requires first separately summarizing the design and construction costs by fiscal year and then totaling them. I can easily accomplish this in MS Access by creating intermediate queries but I don't know how to do it in Filemaker Pro which I only use infrequently.
Senior Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros