Hi Outsystems community,

I'm just wondering if any of you have implemented an excel function like "goal seek".

my current workaround is doing loop but this would take several thousands of looping and it doesnt get the exact result.

As far as I can remember, Goal Seek will use something like Linear Programming to find the optimal values for each parameter.

Maybe you can implement that in OutSystems :) It's much more efficient than looping. For real arguments Linear Programming is pretty fast.