Embedded Formula generates performance issues
Hi everyone,
I have very complex scenario and the best way I found to represent it is by using formulas embedded within formulas. The problem with that is performance. Calculation process takes too much time because of this formula, as the same use other formulas within. Look into de Package created by the system, and have found that the formula uses a select to retrive a vuale, then when invoking the enbeded formula again uses a select to retrive the other value needed and so on with each formula embedded (have six).
So, in order to not open a lot of selects, is there anyway to save the result of that embedded formulas in other variable and not have to embeded formulas within the parent formula?
0