I'm a bit undetermined about the structural design of a business assessment in FileMaker.
Here's what I need and have:
I display the positions table, which contains the fields year, company, positionText and a calculation field with a fix value for every time period that has records in the table "Values" (M1...M12, Q1-Q4,Y). The "Values" table contains various fields for planning figures, actual figures and calculations with these figures.
Basically it looks like this:
year | company | category | customer or other planning positions | Y planning Fix* | Y actual/planning* | Y Delta* | Y actual* | Jan planning Fix* | Jan planning R* | Jan actual planning* | etc.. for every month and the quarters
* field in the "Values" table
Then there should be sub summaries by categories. These sub summaries should either show a total of the planning figures or subtract totals from other sub summaries.
Long story short: I'm a bit undetermined whether I should use the FileMaker sub summaries (part definition) with a lot of "hacks" and unstored calculations or create actual records for the (fake) sub summaries and use a lot of script triggers to update the values. I tend toward the second solution and think it's better for the overall performance.