question

vinom5292 avatar image
0 Likes"
vinom5292 asked vinom5292 commented

subtract the Two Rows of same column in statistics Collector/Calculated Table

Hello,

I have created a statistic collector in which I have column called as "OK TRAYS CUMULATIVE". This column stores the cumulative input to the Sink 1 on hourly bases.

But at the same time, I wish to subtract the Row Values of this column and create a new column.

I tried using Calculated Table, but unfortunately it offers only column to column subtraction.

Example = 361 - 179 = 182 and so on..

1726431767987.png


Can you please help me understand the way to subtract the values of the row in the same coloumn?Final Dashboard.fsm


Thanks,

vinom

FlexSim 24.1.1
calculated tablestatistic collectorsubstraction
1726431767987.png (87.5 KiB)
final-dashboard.fsm (41.6 KiB)
5 |100000

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

1 Answer

Felix Möhlmann avatar image
0 Likes"
Felix Möhlmann answered vinom5292 commented

You can add an extra column to the statistics collector that stores the difference between the cumulative value of the current and previous row.

final-dashboard_1.fsm


final-dashboard-1.fsm (636.1 KiB)
· 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.

vinom5292 avatar image vinom5292 commented ·

Thank you so much Felix!

0 Likes 0 ·