I have a list and I want to add up some columns. There is one column(with arrow) I only want to add in if the recipes match(circled columns). Is it possible to do an If statement on an expression in a list? I can't seem to get it to work without errors.
Ok, got the .fsl loaded and it worked until i made it dynamic(then says puller required) but I did get my if statement working based on your example..i was missing the "return"..still trying to learn the syntax of everything! Thanks for your help. Here is what I ended up using-
if (value.RecipeIndex==value.SourceSwingBinRecipeIndex)
return value.as(FlowTank).content +value.SourceSwingBinObject.as(FlowTank).content*value.SourceBinShareFactor+value.WIP_lbs;
else
return value.as(FlowTank).content +value.WIP_lbs;
Thought I replied earlier, i could get a value from another column but never did get the if statement to work in a list.
The value you want to use has to be returned from the code so it will be something like:
if (getFieldValue("RecipeIndex",c,value,puller,entry,pushTime)==getFieldValue("SourceSwingBinRecipeIndex",c,value,puller, entry, pushTime))
return getFieldValue("SourceSwingBin_lbs",c,value,puller, entry, pushTime);
else
return 0;
I came up with a workaround, i put a label on my objects pushing to list(bins) to check for a match with their source bin(returns 1 or 0). Now I can multiply that in my list so only includes inventory if i find a match. I will have to figure out when to update the label whenever inventory changes. Would love to be able to create conditional columns in lists using expressions.
The question is really about accessing the fields in a list from other fields and is possible but not strictly supported. I'll add a request to the dev list to consider adding this capability.
In the attached model is a user command getFieldValue which may meet your immediate needs.
@jason.lightfoot any chance you have that example in version 21.0.3? im using floworks and trying to hit a deadline so afraid to upgrade right now as i typically have had issues.
Attached are 21.0 and a .fsl library which will put the command into your model when you load it.
Any list field is a result of an attribute of the value. You have in any field access to the value. Now you compute the attribute fields of “recipeIndex“ and „sourceSwingl“ by the value field and set conditionally the expression. If those fields aren’t labels or results of expressions than you can get access to them by a Table.query over the global list itself.
14 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.
