Sum unique value that is not token

Question

question

johanbrasch asked Apr 19 2024 at 8:32 AM Jeanette F commented Apr 24 2024 at 4:43 PM

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

Software Version:

FlexSim 23.1.0

list push to list unique row values

capture.png (34.4 KiB)

· 5

Guldberg commented · Apr 19 2024 at 10:03 AM

Could you attach the model

0 ·

johanbrasch Guldberg commented · Apr 19 2024 at 10:08 AM

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

0 ·

pushtolist.png (15.0 KiB)

1713521288438.png (23.5 KiB)

johanbrasch johanbrasch commented · Apr 19 2024 at 10:24 AM

The Field tab in the advanced list options

0 ·

1713522228224.png (18.0 KiB)

johanbrasch Guldberg commented · Apr 19 2024 at 11:34 AM

Cant share model since it includes company data

0 ·

Jeanette F ♦♦ commented · Apr 24 2024 at 4:43 PM

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 ·

Answer 1 · 2024-04-19T12:00:28Z

Joerg Vogel answered Apr 19 2024 at 12:00 PM

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.

question