Global Table Equation

Question

question

Rober G asked Aug 24, '23 Rober G commented Aug 24, '23

Global Table Equation

Hi! I hope you are well :)

I have the following control policy (T,S)

I wish to save the order quantity needed to obtain level S to my "Squantity" global table, so that once the lead time is over the Inventory is updated with the "Squantity" corresponding to the token.type. As seen below the S value is the Set Quantity S from my global table "MaximumS" minus the Current Inventory from "Buunker Bulk Inventory". This equation is however causing error for me.

My "Update INV WIth S" can successfully obtain the value once the lead time has passed, however as stated I am struggling to save the S Quantity. Could you please explain where I went wrong in Figure 1?

Kind Regards
(T,S).fsm

Software Version:

FlexSim 23.0.10

process flow tables global tables control policy

1692886085149.png (13.8 KiB)

1692886125687.png (14.0 KiB)

ts.fsm (73.6 KiB)

Answer 1 · 2023-08-24T15:02:07Z

Jason Lightfoot answered Aug 24, '23 Rober G commented Aug 24, '23

MaximumS is formatted as a string - change it to numeric (or convert the string to a numeric on the fly).

· 3

Rober G commented · Aug 24, 2023 at 03:20 PM

Awesome, @Jason Lightfoot is this achievable through using the function string.toNum() ? :)

Trying it out now to edit the flex script directly, just a foreign concept.

0 ·

Jason Lightfoot ♦ Rober G commented · Aug 24, 2023 at 06:14 PM

I'd right click the column and change it to string data - it's what people will expect and you can then use the data for comparison queries etc. if needed.

The syntax for getting the numeric value of the string cell will be something like this:

Table("GlobalTable1")[1][1].as(string).toNum()

1 ·

Rober G Jason Lightfoot ♦ commented · Aug 24, 2023 at 06:14 PM

Thanks a lot!

0 ·

question