OverviewFormula Variables enable system calculated
Quantity Per and/or
Price values based on user-defined formula expressions & variables added to Configuration Selection Component records. These formula calculated values are derived when involved selection/component selections are made, and the Quantity Per/Price output values are displayed within the Configuration Session, similarly to those for Components not using Formula Variables.
Processing1. Configuration Selection Component
NOTE Although there is a separate menu option under the ‘Sales Order Setup’ menu, it is advised that Configuration Selection Components be created and maintained by using the Configuration Group > Group Selections tab > Configuration Selection button > Selection Components tab > Configuration Selection Components tab > New Selections Components button
Fields
Use Formula for Qty (Optional): When checked, enables the Quantity Formula field. When a formula is to be used, the result supersedes the Qty Per for the Configuration Selection Component.
Quantity Formula (Optional): Formula for Qty Per calculation (will override the Qty Per value as set), which may be based on 1 or more Formula Variables defined in Formula Variables grid.
-
Valid values are Formula Variable(s)*, numbers, parenthesis, spaces, the words “IF”, “THEN”, “ELSE” and the operators: * (multiply) + (add) - (subtract) / (divide)
-
*See Formula Variables below (section 2. Formula Variables) for a description and instructions as to how to create these.
NOTE The Formula Variables must be defined before the ‘Quantity Formula’/'Price Formula' field can be populated with them.
Use Formula for Price (Optional): When checked, enable the Price Formula field. When a formula is to be used, the result supersedes the Price for the Configuration Selection Component.
Price Formula (Optional): Formula for Price calculation, which may be based on 1 or more Formula Variables defined in Formula Variables grid.
-
Price Formula can be constructed using the Formula Variable(s)*, numbers, conditions “IF”, “THEN”, “ELSE” and the operators: * (multiply) + (add) - (subtract) / (divide).
-
See Formula Variables below (section 2. Formula Variables) for a description and instructions as to how to create these.
NOTE The Formula Variables must be defined before the ‘Quantity Formula’/'Price Formula' field can be populated with them.
EXAMPLE Consider a formula variable
AA is created with '
Source Value Entity' as 'Selection Component Specified Price' so that variable value is set to '
Price' on the source Selection Component. Let us consider the '
Price' set on the source Selection Component is 10. Now the user can set the '
Price Formula' as '2*AA' so the final '
Price' per Quantity on the Configuration Session is calculated as 2*10 = 20.
Here are some other (random) sample formulas:
- IF AA = 10 THEN 20 ELSE 100
- (4 + AA) * 3
- IF AA = 5 OR AA = 10 OR AA = 15 THEN AA*10 ELSE AA*15
- 4 * (AA/2)
Formula Value Rounding Option (Optional): Used to define the rounding method used in the resulting value derived from Formula Variables. Options are
-
Standard (standard rounding to decimal precision defined)
-
Truncate to Integer (discard decimals)
-
Next Integer (will round to next whole number)
Number of Decimals (Optional): Number of decimals allowed (rounded to) when using the "standard" rounding method (can be set to be up to 6 places).
2. Formula Variables
Navigation
Configuration Selection Component > Formula Variables tab
Processing
When ‘Use Formula for Quantity’ is checked, upon Save of the Configuration Selection Component record, a tab appears at the bottom of the page labeled ‘Formula Variables.'
In deriving the Qty Per or Price based on a formula, the result will be rounded based on the setting for ‘Formula Value Rounding Option’ and will be rounded to the ‘Number of Decimals’ defined in that field.
NOTE The Formula Variables must be defined before the ‘Quantity Formula’ field can be populated.
-
Click on ‘Add’, define a 2-character alpha value for the ‘Formula Variable’ identifier.
-
Select ‘Selection’ or ‘Selection Component’ from the dropdown for ‘Source Value Entity.'
-
Select the ‘Source Group’ for the Configuration Group that the formula is associated with,
-
Select the ‘Source Selection’ for the Selection that the formula will be based on and,
-
If using the “Selection Component ” option, select the ‘Source Component’ that the formula will be based on.
Fields
Formula Variable: User-defined 2-character upper-case alpha-only value. Letters A through Z.
Source Value Entity: The “source” of the entity that the formula is based on. Options are;
-
Group: Returns the summation of the input quantities from the Configuration Session Selections within this Configuration Group.
-
Selection: If using 'Boolean for Selection Value', returns a boolean value (1 if the Session Selection exists, 0 if it does not). If not using 'Boolean for Selection Value', returns the Session Selection Quantity.
-
Selection Component: The variable is set to the Configuration Session Component Qty Per, created from the source Selection Component.
-
Selection Component Cost: The variable is set to the cost of the Configuration Session Component, created from the source Selection Component.
-
Selection Component Specified Price: The variable is set to the value from the Price set on the source Selection Component.
-
Selection Component Product Price: The variable is set to the Price Engine derived price from the Product Master referenced on the source Selection Component.
NOTE Source Component
can be itself when Price source is '
Selection Component Specified Price' or '
Selection Component Product Price'.
NOTE Source Component must reference a Product when Price Source is ‘
Selection Component Product Price’.
NOTE Source Component cannot be itself when Price Source is ‘Selection Component Selected Price’.
Source Group: When ‘Source Value Entity’ is Group, Selection or Selection Component, this is the Group (required for each said selection made) from which the value for the variable is derived.
Source Selection: When ‘Source Value Entity’ is Selection or Selection Component, this is the Selection (required for the said selection made) from which the value for the variable is derived.
Source Component: When ‘Source Value Entity’ is Selection Component, this is the Selection Component (required for the said selection made) from which the value for the variable is derived.
Default Value: Default value used if the Source entity does not exist, is not selected within the session or returns no value.
Boolean for Selection Value: When ‘Source Value Entity’ is Selection, when this field is checked, use a value = 1 if that Selection is made in the Configuration Session, otherwise value used = 0.
SEE ALSO
