sum value in array

Question

question

Jason P2 asked Oct 31, '19 Joerg Vogel answered Nov 1, '19

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)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

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

Regan Blackett answered Oct 31, '19

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;

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

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

Joerg Vogel answered Nov 1, '19

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);

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

question