topic Re: Sum unique value that is not token in FlexSim Forum

Sum unique value that is not token

johanbrasch — Fri, 19 Apr 2024 08:32:47 GMT

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

Re: Sum unique value that is not token

guldbergdk — Fri, 19 Apr 2024 10:03:09 GMT

Could you attach the model

Re: Sum unique value that is not token

johanbrasch — Fri, 19 Apr 2024 10:08:12 GMT

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

Re: Sum unique value that is not token

johanbrasch — Fri, 19 Apr 2024 10:24:07 GMT

The Field tab in the advanced list options

Re: Sum unique value that is not token

johanbrasch — Fri, 19 Apr 2024 11:34:10 GMT

Cant share model since it includes company data

Re: Sum unique value that is not token

joerg_vogel_HsH — Fri, 19 Apr 2024 12:00:28 GMT

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.

Re: Sum unique value that is not token

Jeanette_Fullmer — Wed, 24 Apr 2024 16:43:58 GMT

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.