How to provide calaculated table cell reference?

Question

question

Ankur A3 asked Oct 28 2022 at 5:27 AM Ankur A3 commented Oct 28 2022 at 11:30 AM

How to provide calaculated table cell reference?

Hi Team,

I have collected statistics using calculated table. Now, I want to show it as KPI in performance measure.

I am trying to link calculated table cell in performance measure, but it is showing errors.

Is it possible to do the same?

Thank you!

Software Version:

FlexSim 21.1.5

performance measure calculated table cell reference

1666934676305.png (158.6 KiB)

Answer 1 · 2022-10-28T06:03:58Z

Felix Möhlmann answered Oct 28 2022 at 6:03 AM Ankur A3 commented Oct 28 2022 at 11:30 AM

When using the sampling tool to select the calculated table choose the lower entry. This will add the "Table value" option into the Value field.

Your code isn't working because you first need to cast the treenode reference into a table class variable in order to use the [row][col]-syntax to read entries. You can see how this is done by inspecting the code of the "Table value" option.

1666936998541.png (38.1 KiB)

1666937012691.png (41.6 KiB)

· 3

Ankur A3 commented · Oct 28 2022 at 6:35 AM

Hi @Felix Möhlmann,

Got your point.

But I have 1 question here:

When we provide table keyword while referring "Table" in custom code all the table gets populated including calculated tables. So why we need to convert it in table format again to print the cell value?

Thank you!

0 ·

Felix Möhlmann Ankur A3 commented · Oct 28 2022 at 6:54 AM

Because "reference" points to the node of the calculated table, not the data table. If you want to use the reference variable, you thus have to convert it first.

You can of course just not use the reference and access the table cell directly by refering to it by name, as you describe, with the Table() constructor.

0 ·

1666940035643.png (23.8 KiB)

Ankur A3 Felix Möhlmann commented · Oct 28 2022 at 11:30 AM

Ok @Felix Möhlmann!

Thanks a lot for explanation!

0 ·

question