Writing Syntax for Actions
For a review of Actions related to Scenarios please refer to the article here. Writing actions take the form of an equation:
- ColumnName = MyScenarioValue
If you are ever doubting the name of a column that needs to be used in an action, you can type CTRL+SPACE to have the full list of columns available to you displayed. Alternatively, you can start typing and the valid column names will auto-complete.
Allowed Numerical Syntax
When assigning numerical values to a column, we can use mathematical operators such as +, -, *, and /. Likewise you can use parenthesis to establish a preferred order of operations. Below are some examples of the syntax.
Allowed Numerical Value Syntax
When assigning numerical values to a column we can use mathematical operators such as +, -, *, and /. Likewise you can use parentheses to establish a preferred order of operations as shown in the examples below.
| Business Goal | Action Syntax |
| Increase the unit value by 10% | unitvalue=unitvalue*1.10 |
| Increase the unit value by 10% and add $30 | unitvalue=(unitvalue*1.10)+30 |
Allowed String Syntax
When assigning string values to a column you must use single quotation marks to reference any string that is not a column name. Some examples of changing values with a string are included in the table below:
| Business Goal | Action Syntax |
| Exclude an element by changing the status | status=’Exclude’ |
| Change the product that goes into a BOM | productname=’RM_02′ |
| Set a customer to be single sourced | singlesource=’True’ |