Is there any performance issues of using the results of a formula from one parameter in another formula parameter.
Example:
Parameter A: Parameter B - Parameter C
Parameter B: Parameter D + Parameter E
Parameter C: Parameter E - Parameter D
Parameter D: 10 (example value)
Parameter E: 20 (example value)
I've always tried to make every formula non-dependent on the results of another formula, so in the case of parameter A, I'd typically write that formula as:
Parameter A: (Parameter D + Parameter E) - (Parameter E - Parameter D)
But I'm wondering if there's any reason to continue doing that from a performance standpoint. I've kept the example extremely simple, but the concern is that as the formulas are processed, when processing hits a formula parameter referencing another formula parameter that hasn't been calculated yet, it might interrupt the processing, skip over it until the results of the referenced formula parameter are calculated, and then loop back to process it - causing a performance penalty. Theoretically, these calcs shouldn't take more than a fraction of a second, but I'm wondering if anyone's noticed any real world implications to performance or other issues?