sum value in array

Question

question

Jason P2 asked Oct 31 2019 at 8:10 PM Joerg Vogel answered Nov 01 2019 at 5:05 PM

sum value in array

I have a token for each warehouse order. I need to get the total quantity per order, so I need to sum up the array token.Qty. How do I create a label that sums the array for example token.OrderQty = 11

Software Version:

FlexSim 19.2.3

array

capture87.png (15.8 KiB)

Answer 1 · 2019-10-31T20:22:20Z

Regan Blackett answered Oct 31 2019 at 8:22 PM

You could copy this and paste it into the Code Editor for the Value field on an Assign Labels activity:

Array theArray = token.Qty;
double aggregate;
 
for(int i = 1; i <= theArray.length; i++)
    aggregate += theArray[i];
    
return aggregate;

Answer 2 · 2019-11-01T17:05:10Z

Joerg Vogel answered Nov 01 2019 at 5:05 PM

By a table query over the array length with a SUM clause

Array qty = [12,1.23,3.56];
double sum = Table.query("SELECT SUM($2) FROM $1",
      			    /*$1*/ qty.length,
      			    /*$2*/ qty[$iter(1)]
  			)[1][1];
print(sum);

question