Create a global variable that tracks the running total. Then compare this variable with the current inventory to see if it exceeds the max. Something like this:

Global NumberVar TotalInven;
NumberVar NewTotal;
NewTotal := {item.qty} + TotalInven
if NewTotal < 1000 Then
{
    //Update the grand total
    TotalInven := NewTotal;
    //return the current quantity
   {item.qty};
}
else
{
    //Overwrite the NewTotal with the value to return (to keep from creating another variable. This is whatever is left from the remaining 1000
    NewTotal := 1000-TotalInven;
    //Update TotalInven
    TotalInven := 1000;
    ///return the NewTotal value
    NewTotal;
}

You'll probably have to debug this a bit, but it should be close to what you want.

I added your formula, but it highlights the IF statement "The remaining text does not appear as part of the formula" upon saving the formula!

Do you know why it does not want to save it?  We are on the right track and thank you for that!

I did replace { with (

Edited by Hala - 18 Feb 2008 at 6:36am