Doubt about function

Fri, 11 Sep 2015 19:36:01 GMT

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

Re: Doubt about function

MK_QSL — Fri, 11 Sep 2015 19:39:10 GMT

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

MarcoWedel — Fri, 11 Sep 2015 20:19:29 GMT

please post a sample app.

regards

Marco