Minimum value from specific column

Question

question

Milan U3 asked Dec 7, '20 Ben Wilson commented Dec 10, '20

Minimum value from specific column

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!

Software Version:

FlexSim 20.2.3

flexsim 20.2.3 event-triggered source

· 1

5 |100000

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

Ben Wilson ♦♦ commented · Dec 10, 2020 at 02:05 PM

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.

0 ·

Answer 1 · 2020-12-07T11:45:40Z

Krzysztof J answered Dec 7, '20 Milan U3 commented Dec 7, '20

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

milandurackau3.fsm (40.8 KiB)

· 1

5 |100000

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

Milan U3 commented · Dec 07, 2020 at 12:56 PM

Thank You very much, it works!

0 ·

question