5.5.6.4. Computing many columns

<< Click to Display Table of Contents >>

Navigation:  5. Detailed description of the Actions > 5.5. Standard > 5.5.6. Calculator (High-Speed action) >

5.5.6.4. Computing many columns

 

You can compute many different (new) columns inside the same clip0163Calculator Action. For example, here is an example that computes the column “weight” that is the “weight of the connection between 2 individuals (A and B) inside a telecommunication network”.

 

ANATEL~3_img456

As you can see in the screenshot above, the column weight is the arithmetic mean of the 2 variables “WeightAB” and “WeightBA”. These variables are defined on the other tabs inside the clip0163Calculator Action:

 

ANATEL~3_img458ANATEL~3_img460

 

 

To be able to use the variables “WeightAB” and “WeightBA” inside the expression of the “Weight”, we must enable these 2 checkboxes:

 

clip0176clip0177

 

 
More precisely, if you want to use a column X inside the expression of the column Y, you need to:
 

a)Enable the “is Input Var” checkbox inside the tab of the column X.
 

b)Move the tab of the column X on the left-side of the tab of the column Y. (because the different expressions are evaluated in the order from the left to the right).

 

Use the 2 arrows ANATEL~3_img461 to re-order the tabs.
 
clip0181

clip0183

 

 

Use the ANATEL~3_img462 and the clip0180 buttons to add/remove tabs.

 

clip0184clip0182