Greetings,

I have a feeling I can find a workaround for this... but at this point, I am curious what others have done.

I have a series of calculations that must be performed to get an ultimate result.

The issue is, it is about 9 calculation fields deep.. and each subsequent calculated fields, relies on a previous field.

So by the ninth calculation... all 8 other calcs must be evaluated before it can perform the ninth.

This is causing major slow downs by the end of all this.

It handles the first 6 with ease.. but once I start getting near the end... it is a snails pace.

I know this has to do with indexing... and since these are from related tables... it won't allow indexing.

I have tried a couple of different way to do these calcs.. but in the end.. I still have to perform them in a certain order.

One idea was to write a script, that temporarily stores the calc in an indexed variable.. then perform all of the calcs from there... but I don't really see how that would speed things up.

If you have several calcs like this.. does anyone know any tricks to speed this up... or force minimal indexing?

It's hard to say anything with practically no details, but do you really need the interim fields?