[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 412
  • Last Modified:

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
0
danzzz
Asked:
danzzz
  • 2
1 Solution
 
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
            else
                  myArray(i) = myArray(i) - subtract
                  exit for
            end if
      Next
      response.write join(myArray,",")

%>
0
 
SammoCommented:
It is probably easier to calculate:

Previous Stock - Delivered Stock = New Value

for each line of stock?
0
 
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
0
 
SammoCommented:
Ah ok I follow now, the code above from ryancys should do what you want.

Sam
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now