Within VBA, it is possible to create "Loop & Exit"/"While/Wend" or "Do Loop" functions. This allows formulae to continue running until an answer is produced.
Within Anaplan, there are workarounds, but none are truly as flexible, and all have their limitations.
Creating this functionality would close the gap on some of the final areas within excel that, as model builders, we still need to creatively workaround.
Very simple Excel Example:
Do While True
count = count+1
If count = 10 Then
Exit Do
End If
Loop
This can be used in innumerable use cases, but as an example in call centre planning, to calculate capacity:
#Agents = number of reps available
Calls = IntCeiling(3600 / AHT)*#Agents
xAgent = Agents(SLA, Target Answer Time, Calls, AHT)
("Agents" as per the Anaplan formulae "Agents")
While (xAgent > #Agent) And (Calls > 0)
Calls = Calls - 1
Wend
CallCapacity = Calls