question

johanbrasch avatar image
0 Likes"
johanbrasch asked Jeanette F commented

Sum unique value that is not token

I want to summarize the number content number of a specific type in a list. But the token containing the value is seen as the unique value and the summarization does not work. Is there a solution to this? See picture. I want to summarize the far right column based in the middle column ("Types").capture.png

FlexSim 23.1.0
listpush to listunique row values
capture.png (34.4 KiB)
· 5
5 |100000

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

Guldberg avatar image Guldberg commented ·

Could you attach the model

0 Likes 0 ·
johanbrasch avatar image johanbrasch Guldberg commented ·

To be more clear. I want to remove the token ID column and use the label: "Types" instead.

Here is the logic in the process flow

pushtolist.png


1713521288438.png

0 Likes 0 ·
pushtolist.png (15.0 KiB)
1713521288438.png (23.5 KiB)
johanbrasch avatar image johanbrasch johanbrasch commented ·

The Field tab in the advanced list options1713522228224.png

0 Likes 0 ·
1713522228224.png (18.0 KiB)
johanbrasch avatar image johanbrasch Guldberg commented ·
Cant share model since it includes company data
0 Likes 0 ·
Jeanette F avatar image Jeanette F ♦♦ commented ·

Hi @johanbrasch, was Joerg Vogel's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 Likes 0 ·

1 Answer

Joerg Vogel avatar image
0 Likes"
Joerg Vogel answered

You can summarize values by type in a single partition.

If you have a global list you can get access to all partitions of a list in the model tree. But you must aggregate list values and fields from the tree structure yourself. Then you can query this data and get the sum of a field.

maybe you can push your values to a different list, which builds sum values directly.

5 |100000

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