I'm developing an FM system for entering figures against Tasks. There is a hierarchy, top level contains Programmes, which can have many Projects which in turn can have many Work Packages which in turn can have many tasks which can have many Costs (another related table). At Cost level I am storing the actual costs, these are mostly in GBP but certain programmes use Euros and have a different layout to allow a more detailed breakdown of costs, therefore I'm using 2 different cost fields. At Cost level I have a field CostFieldSelector which is a calculated field which does a logical lookup, if currency = GBP use Cost GBP otherwise use Cost EURO.
At Task level I have a field called SpendToDate which is a calculated field: Sum(Costs::CostFieldSelector) and so on up the related tables to give SPendToDate figures for each Work Package, Project or Programme.
The problem is when in List views the layouts take far too long to display as FM is doing some heavy number crunching, especially worse the higher up the related tables you go.
Is there a better way to do this?
Many Thanks in advance.