Doubt about function

[#1]

Hi

I have an amount of money and a budget and a lot of forecasts

Real,

Budget,

Forecast 1,

Forecast 2,

Forecast 3,

Forecast 4,

Forecast 5

when i choose forecast 5 i have to do forecast 5 / forecast 4. When i choose forecast 4 i have to do forecast 4/3 and so on.

The problem is this. If i choose forecast 5 and is 0 i have to do frcs4/3 but if the forecast 4 is 0 i have to do forecast 3/2 etc.. and so on.

Is there a function that recognises the first value that is no 0 in a number o fields or something like that?

Regards

[MK_QSL]

You have to replace 0 value with previous forecast in script to overcome this problem.

[MarcoWedel]

please post a sample app.

regards

Marco