Sum unique value that is not token

[johanbrasch]

[ FlexSim 23.1.0 ]

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").

[guldbergdk]

Could you attach the model

[johanbrasch]

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

[johanbrasch]

The Field tab in the advanced list options

[johanbrasch]

Cant share model since it includes company data

[joerg_vogel_HsH · Accepted solution]

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.

[Jeanette_Fullmer]

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.