Formula, one field complex or multiple table field simple

  • Thread starter Thread starter DbMstr
  • Start date Start date
D

DbMstr

Please comment on whether it is best, (execution speed wise), to reach a complex result built by having a complex formula broken down into simpler sequential multiple simple formula fields with each field using the value of aprevious field in its calculation and then the final field containing the complex result OR if whether it is best to use one field with a very complex formula to reach the same result?
 
Please comment on whether it is best, (execution speed wise), to reach a
complex result built by having a complex formula broken down into simpler
sequential multiple simple formula fields with each field using the value of
a previous field in its calculation and then the final field containing the
complex result OR if whether it is best to use one field with a very complex
formula to reach the same result?
Click to expand...

Breaking things down into smaller pieces so you can have individual
results for each piece will definitely require more processing. In this
context the answer is that it's better (performance-wise) NOT to invoke
extraneous processing whenever possible.
 
Back
Top