how to sum values of a label in a list by partition id

Question

question

Durga Ghosal asked Mar 20, '19 Durga Ghosal commented Mar 22, '19

how to sum values of a label in a list by partition id

how to sum values of a label in a list by partition id or buy another label value.

process flow list

· 2

Sebastian Hemmann commented · Mar 20, 2019 at 02:00 PM

It sounds a bit like you are looking for a "Batch" Activity instead of a List. But maybe you can explain more exactly what you are trying to do (e.g. with a small example model)? So we can figure out how to help you!?

0 ·

Durga Ghosal Sebastian Hemmann commented · Mar 20, 2019 at 02:05 PM

@sebastian.hemmann, I am using list as my inventory/storage, I want to check how much I have in my inventory for each SKU before giving production request, so that I can prioritize the one with low inventory and ignore/delay the one with high inventory. I would just like to check the value and not release anything.

0 ·

Answer 1 · 2019-03-22T05:11:34Z

Joerg Vogel answered Mar 22, '19 Durga Ghosal commented Mar 22, '19

In fact it is a Table.query you are looking for.

double sumlabel = Table.query("SELECT SUM(label2) FROM List1.2")[1][1];
print(sumlabel);

List1 looks like this picture:

The value of variable sumlabel is 40.

Please look into the manual howto get a reference of a partition of a list :

Reference Developer and Advanced User Reference SQL Queries Chapter: Table Selection blue box: Quering Global Lists

item-list-partioned.jpg (20.7 KiB)

quering-global-lists.jpg (92.5 KiB)

· 1

Durga Ghosal commented · Mar 22, 2019 at 11:18 AM

Thank you, worked like a charm. I deleted the partition Id and did "group by" in the query statement and it made it even more easy to use.

1 ·

Answer 2 · 2019-03-21T20:28:51Z

tannerp answered Mar 21, '19 tannerp commented Mar 21, '19

You could try using the information found in this part of the FlexSim User Manual:

This could be applied to a dashboard or other function so you can read the value.

list-entries.png (22.9 KiB)

· 1

tannerp commented · Mar 21, 2019 at 08:31 PM

Here's a specific example where I'm finding the number of items in Partition ID: 3 of "ItemList1" that can be applied with code:

int partID3 = List("ItemList1").entries(3).length;
return partID3;

0 ·

question