AnsweredAssumed Answered

Script variables and 'Let' calculations

Question asked by tays01s on Sep 2, 2018
Latest reply on Sep 5, 2018 by dougnewnham

I have a script that replaces 6 fields' contents, each with a specific list of 51, by evaluating a calculation from another table. The calculations use 'Let' to set calculation level variables from the result of an SQL calc.

 

Because of the number of calcs, it takes 2-3 seconds to complete the script so I am pondering how to speed it up. For 4 of the fields, 1 of the 'Let' variables will be the same, so:

a) Can I set a script level variable early the in script and pass this into the 'Let' calculation?

b) Will such rearrangements make much difference to 'script speed'?

Outcomes