Ventana software support forum

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???

Hi

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

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.

Tnx Tony, I will try