Ventana software support forum

My model cannot run because of lookup that i have build, the problem is appear at 0/25, and the command appear after im running the model is "Above -Sales lookup- computing -sales multiplier-. "

Can anyone help me to solve thos problem

My model

Azri, good evening.

This is your lookup function: [(0,0)-(52,1000)],(1,200),(25,250),(40,200),(52,150)

It means that you are setting a lookup function for x varying from 1 to 52, and y varying from 150 to 1000

However, x = (Retailer inventory/average retailer inventory) is varying from 0 to 1053.06, reaching this maximum value at time 4.25. Once 1053.06 is higher than the upper limit you set up, which is 52, Vensim is returning you that alert at time 0.25, the very first time x went out the boundaries you set up.

One possible way to solve this issue is using the following lookup function: [(0,0)-(1055,1000)],(1,200),(25,250),(40,200),(52,150),(1055,150)

You have to be sure that for every x higher than 52, y will be always 150.

I hope I have been clear.

Kind regards,

Bruno.