question

Pinakin K avatar image
1 Like"
Pinakin K asked Matthew Gillespie edited

How to retrieve value by percentage from global table

I want to use this table for taking the values from the 2nd column and giving that value to a Process Flow label. And I also want to use these values in the source, like create by percentage, but i want to reference to global table

global table
percentage.png (3.0 KiB)
5 |100000 characters needed characters left characters exceeded

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

Matthew Gillespie avatar image
5 Likes"
Matthew Gillespie answered Matthew Gillespie edited

You should use the dempirical command. You already have the global table set up correctly.

dempirical("GlobalTable1")

This command uses the first column for percentage values and the second column for return values.

You can also use the empirical and cempirical commands, which are similar but include some interpolation between values.

See the attached model.

valuebypercentdempirical.fsm


5 |100000 characters needed characters left characters exceeded

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

Emily Hardy avatar image
1 Like"
Emily Hardy answered Pinakin K commented

One way to do this is to create a trigger that sets the Item Type upon creation based on percentage, and then sample the global table.

You can also sample the Type if you would like. I've attached a sample model with the above logic that also changes the color depending on the Type. Hope this helps!

pinakin-support.fsm


· 1
5 |100000 characters needed characters left characters exceeded

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

thank you!

I want to use this in a process flow, i won't be using 3d environment for this. I want to create tokens using these percentages, and also would like to give the values of the second column to one of the process flow labels i have specified.

0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

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