I'm having trouble with one column in a calculated table - slurry tph. I'm trying to divide a total (total slurry tons) by the model run time (hours column). It's not accepting Model.time/hours(1). It also won't let me divide my total by my hours column. If i hardcode a number in, it works (but only accurate at end of model).
Hi @Amy M3, I think I've found a solution. I added a column to your stats collector called "TimeH" which measures the time in hours. I then use that in the Slurry Overall Totals calculated table with a "aggregated operation on two columns" dividing the slurry tons by the TimeH (see metric 6). I'm not sure why it wasn't liking the original code, but hopefully this will be a solution for you.
Hi @Amy M3,
I think you are using the "Operation on column and value" option. Instead, do the "Custom expression" and wrap your flexscript in curly braces:
15 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.
May we collect and use your data?
Learn more about the Third Party Services we use and our Privacy Statement. May we collect and use your data to tailor your experience?
Explore the benefits of a customized experience by managing your privacy settings for this site or visit our Privacy Statement to learn more about your options.
