Author variant formula in the grid

You can author variant formula by selecting features from the grid. This is the recommended method.

You can also author variant formula by typing the formula in the text editor. This is recommended only for complex formula or combinations that cannot be selected on the grid.

Procedure

1. Find and open the product for which you want to author variant formula.
2. Select the BOM lines for which you want to apply variant conditions and click the Variant Conditions tab.The BOM lines you selected are displayed as columns at the top. You can hover over the column header to view the complete name of the BOM line.
3. (Optional) Enable Variant Formula column in your work area, if it is not available.This column displays the variant formula for each BOM line, and you can edit this in the grid. In your work area, click Settings . Click Arrange and search for the Variant Formula column. Select the Variant Formula column and click Move up to bring it to the top of the Arrange panel.
4. Click Start Edit on the top of the grid
5. Make the required selections in the grid.
6. Click Save Edits . Note You can export the contents of the Variant Conditions grid view to Microsoft Excel if required. To do this, click Export to Excel . The Export to Excel panel appears if you select Expand All. The icons for the user positive, user negative, and configured out objects, and the corresponding text is displayed in the panel. You modify the default names if required, and click Export. When you specify names for the icons, other than the default ones, you can include spaces in the names. However, the text box cannot be blank, you must specify a name or retain the default values. If there are no icons, a message which indicates that the contents are exported to Microsoft Excel is displayed.