Minimum value from specific column

[milan_durackaDVYZD]

[ FlexSim 20.2.3 ]

Hello, I am still beginner in Flexim a I´d like to ask You for help. I need to use “Event-Triggered Source” -> “OnContentChange”-> ”Increase to exact value” -> define this exact value (let´s name it “X”) as distinction between variable Y (value defined in the table) and minimum from values of specific column in the table. Something like this: X = Y - min(Col 3). This “X” should be the parameter “quantity” in “event-triggered source”. I don´t know how to get this result in custom code. Could You help me please?

Thanks a lot!

[krzysztof_jurczykF5GXD · Accepted solution]

Hello. Try to use SQL query as I have proposed in the attached model.MilanDurackaU3.fsm

[milan_durackaDVYZD]

Thank You very much, it works!

[Ben_WilsonADSK]

Hi @Milan U3, was Krzysztof J's answer helpful? If so, please click the red "Accept" button on 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 unaccept and comment back to reopen your question.