asked on

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.

Thanks,
Dan

ASKER CERTIFIED SOLUTION

Ryan Chong

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sammo

It is probably easier to calculate:

Previous Stock - Delivered Stock = New Value

for each line of stock?

danzzz

ASKER

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

Sammo

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

Sam