topic Re: Label not being pulled correctly from Data table in FlexSim Forum

Label not being pulled correctly from Data table

adilmlk — Wed, 01 Feb 2023 18:37:11 GMT

[ FlexSim 21.2.4 ]

Global Table Model.fsmI'm using a global table to pull volume percentage by "type" but it seems the volume is not being pulled correctly. All the packages are coming to pallet 60 despite it having only 0.01% of total volume

Also attaching the excel file which I imported. Volume Analysis.xlsx

Re: Label not being pulled correctly from Data table

kavika_faleumu — Wed, 01 Feb 2023 19:45:08 GMT

Hey @Adil M, I think I found the problem. Your table's percentages were adding up to 1.2 total. If you check the documentation for dempirical distribution, you had the right formatting for your table, but it states that percentages must add up to 100.

So, after changing your decimal values to be whole numbers, they now add up to 120. Your distribution seems to work now, spawning other types, but now you have to balance your percentages to add up to 100 so that the later types get picked.

Note: You can have decimals in your percentage (i.e., 5.2, 6.86); they just need to add up to 100. If they add up to less, then whatever is leftover gets defaulted to the last value (as you saw with your initial problem). If they go over, you get the current behavior as shown in the screenshot.

Re: Label not being pulled correctly from Data table

adilmlk — Wed, 01 Feb 2023 20:30:48 GMT

Thank you! I was able to fix the issue:)