Hello,
How can I calculate the value difference between two successive rows in the 'EndTime' column of a Statistics Collector table ?
Thanks!
Hello,
How can I calculate the value difference between two successive rows in the 'EndTime' column of a Statistics Collector table ?
Thanks!
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.
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.
12 People are following this question.
FlexSim can help you understand and improve any system or process. Transform your existing data into accurate predictions.
FlexSim is a fully 3D simulation software environment. FlexSim can be used to simulate any process in any industry.
FlexSim®, FlexSim Healthcare™, Problem Solved.®, the FlexSim logo, the FlexSim X-mark, and the FlexSim Healthcare logo with stylized Caduceus mark are trademarks of FlexSim Software Products, Inc. All rights reserved.
Privacy | Do not sell or share my personal information | Cookie preferences | Report noncompliance | Terms of use | Legal | © Autodesk Inc. All rights reserved