Hi all ,
I am trying to make model not to (re)calculate in some scenarios a variable and (re)calculate only when a boolean is ticked . I did some performance scenarios analysis of calculations (counting seconds on new input ) using boolean and if statement and what i do not understand is why the calculation time after an input is not reducing when the boolean is not ticked for all records?
Example two scenarios comparing calculation time :
a) E = B+D - when i want the model to apply always solution 1, so always B
b) E=C+D - when i want the model to calculate B only when i want solution 1 to be applied
C= if "Do not Apply solution 1 ? " then A else B
A, D = functions independent of input - i expect will not be recalculated on new input?
B = function dependent of input - i expect will not be recalculated on new input when "Do not Apply solution 1 ? " is ticked for all records
C - I expect will not be recalculated on new input when "Do not Apply solution 1 ? " is ticked for all records?
E - I expect will not be recalculated on new input when "Do not Apply solution 1 ? " is ticked for all records?
This E is used in the module afterwards to get to a final calculation.
What i do not understand: calculation after new input takes almost same number of seconds when i apply formula a) (6.7 sec) as when i apply formula b) (6 seconds) with "Do not apply solution "? ticked for all records . I would have expected half of the time in b) with "Do not apply solution ?" , but this is not happening
Thanks,
Andreea
