I think there is a problem with the Multiple Operations tool. Below is my simple example of the issue. However I’ll also try and describe the setup.
I have four cells in a column representing the parameters of the equation:
y = mx + c
Where M = 4, X = 2 and C is the function =RAND(). Therefore the value of Y varies each time the model is recalculated.
If a column of values for X is set-up, any value would do, and then use Multiple Operations to calculate corresponding values for Y. Nothing out of the ordinary at this point.
Next change the column of values for X to the same value and force a recalculation. NOW each of the calculated values for Y MUST be different because of the RAND() value for C. BUT their not.
Should I report this as a bug?
Multiple Operations Example.ods (18.5 KB)