Global Table Equation

[roald_w]

[ FlexSim 23.0.10 ]

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

[jason_lightfootVL7B4 · Accepted solution]

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

[roald_w]

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.

[jason_lightfootVL7B4]

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()

[roald_w]

Thanks a lot!