Subtracting values from an array ASP

Say I have an array - dim myArray(3) - that holds four values: 4,2,0,0. The total values held in the array = 6. I want to subtract 5 from the the array so the new values would be to 0,1,0,0. What is the best way to do this.

I need to subtract delivered stock from previous orders in a data table. I'm guessing putting the values into an array first and then doing the maths before updating the values again would be the best way.

Who is Participating?
Ryan ChongCommented:
not too sure your logic behind, but you can try this...

      myArray = Array(4,2,0,0)
      subtract = 5
      for i = 0 to ubound(myArray)
            if subtract > myArray(i) then
                  subtract = subtract - myArray(i)
                  myArray(i) = 0
                  myArray(i) = myArray(i) - subtract
                  exit for
            end if
      response.write join(myArray,",")

It is probably easier to calculate:

Previous Stock - Delivered Stock = New Value

for each line of stock?
danzzzAuthor Commented:
An invoice/packing list is generated from Indonesia each time a shipment of furniture is made. The container might fulfil some orders and parts of others. Adding to the confusion there are five different suppliers. As soon as the furniture is shipped the company lists the furniture as stock so the sales team can start selling it.  

Previous Stock - Delivered Stock = New Value. This is what I'm doing but across different placed orders (database columns). I create a temporary column in the stock table for each stock order list and when that entire order has been fulfilled then I will delete the column. Depending on how quickly the suppliers manufacture the furniture they may send for example 20 chairs which might have to be matched to more than one order.

thanks for reading this
Ah ok I follow now, the code above from ryancys should do what you want.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.