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
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
CallCapacity = Calls
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.