No, Audrey.
Peter
On Nov 14, 2008, at 6:23 PM, Audrey Akhavan wrote:
Hi Peter,
Do any of your calculation fields or scripts contain If statements
with variables in all caps (e.g., If ($VAR = ...)?
Audrey :-)
At 02:02 PM 11/14/2008, Peter Kilcoyne wrote:
Thanks, I hadn't thought of that. But I will try it. I remember doing
that years ago with some success.
Peter
On Nov 14, 2008, at 3:56 PM, Richard S. Russell wrote:
On 2008 Nov 14, at 14:46, Peter Kilcoyne wrote:
I have many, but some can't be changed because they used fields
that require a calc to activate. But thanks for the input.
One thing you might try is the old technique of dividing stuff into
2 piles and seeing which pile still contains the problem, then
repeating with that pile until you've narrowed the problem down to
a single item.
In this case, that would be something like duplicating your current
layout into 2 clones, throwing away the top half of one and the
bottom half of the other, then going to each of the clones in turn
to do whatever it is that sets off the problem. Chances are one of
the clones will run just fine, while the other will continue to
hang you up. It's the latter that you should concentrate on,
repeating as needed until you're down to the thing that will not
die.
In my experience, the main source of really long calculations is
having a string of relationships, in which Table A refers to Table
B, which refers to Table C, which refers to Table D, which may
refer back to Table A, which refers to Table E, etc. It's all that
cross-referencing and recalculating which makes everything run
slowly. And the problem is REALLY exacerbated if there's a Sum or
Average function operating anywhere.
