question

Ben avatar image
0 Likes"
Ben asked Ben answered

Calculating Differences Between Successive Rows

Hello,

How can I calculate the value difference between two successive rows in the 'EndTime' column of a Statistics Collector table ?


Thanks!

FlexSim 24.2.1
calculated tablestatistic collectorrows
· 1
5 |100000

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

Logan Gold avatar image Logan Gold ♦♦ commented ·

Hi @Ben, was Felix Möhlmann'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 ·
Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered

You can read any value in the collector table through "collector.getValue(row, column)". The current row is accessible via "data.rowNum".

So to get the difference between a column from the current and previous row you would use

collector.getValue(data.rowNum, 1) - collector.getValue(data.rowNum-1, 1)

Which of course only works if there is a previous row, so check for that first.

collector-row-diff.fsm


5 |100000

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

Ben avatar image
0 Likes"
Ben answered

Thank you !

5 |100000

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