multiple input

Olger · Post by **Olger** » Mon Jul 24, 2006 12:36 pm

Hello, I have a question.

For example:

Input = 750
Maximum Realisation = 1000
Stock = 4500

I need a formule that checks if my Input is lower then my Max Realisation. If it's lower it needs to fill the gap with goods from my stock. How do i need to do this???

LAUJJL · Post by **LAUJJL** » Mon Jul 24, 2006 12:50 pm

Hi

I do not understand your question.
I think it needs a better formulation.
Regards.
JJ

Post by **Administrator** » Mon Jul 24, 2006 12:55 pm

How about something like

refill amount = if then else ( Input < Maximum Realisation
, expected amount to refill
, 0 )

expected amount to refill = min (
stock , Maximum Realisation - Input )

Tony.

Olger · Post by **Olger** » Mon Jul 24, 2006 1:19 pm

Tnx Tony, I will try

Ventana software support forum

multiple input

multiple input

RE I have a question