Create a product with attributes. You can use these attribute values to create a numeric expressions.

Example

SunHome is a product with the following attributes:

  • Refrigerator Run Time
  • Microwave Run Time
  • Television Run Time
  • House Lights

Each attribute has the datatype defined as number. You must also create an attribute group named Summary of WattHours required and assign it to the product SunHome. The attribute group contains the following attributes.

  • Total daily WattHours required
  • WattHours required for 3 days
  • Battery capacity

Each attribute has the datatype defined as number. You can derive the values for these attributes using numeric expressions.

To populate product attribute values using numeric expressions

  1. From the Products detail page, select SunHome and click Product Console.
  2. Scroll down to the Additional Data section, and click Attributes.
  3. Click Summary of Watthours required Attribute Group. All the attributes listed under the attribute group are displayed.
  4. To associate an expression to an attribute, click the text field next to the attribute in the Expression Column. An expression builder pop up is displayed.

    Selecting any function displays the example syntax on the right on how you can use it.
  5. Click Insert Field. To retrieve the fields for building the expression, click Insert Field and choose Product attributes or Line Item. Line Item allows you to get access to fields at Product and Quote objects as well.
  6. In the Insert Field dialog, click Product Attribute and select the required attributes to derive the values for attributes of SunHome. The following expressions are built for each attribute:
    • Total daily WattHours required:
      Apttus_Config2__ProductAttributeValue__c.Refrigerator_Run_Time_hrs_per_day__c * 140 + Apttus_Config2__ProductAttributeValue__c.Television_Run_Time_hrs_per_day__c * 120 + Apttus_Config2__ProductAttributeValue__c.Microwave_Run_Time_hrs_per_day__c * 1000 + Apttus_Config2__ProductAttributeValue__c.House_Lights_hrs_per_day__c * 200
    • WattHours Required for 3 days:
      Apttus_Config2__ProductAttributeValue__c.Total_Daily_WattHours__c * 3
    • Battery Capacity Needed (50% Discharge):
      Apttus_Config2__ProductAttributeValue__c.WattHours_for_3_days__c * 0.5

    For more common syntax examples, see Examples and Related Syntax for Numeric Expressions.

  7. Click Save.

The expressions are built and the product attribute fields are populated with the value that the expression retrieves.

After completing this process, you must run the Criteria Maintenance job for all expression fields. Refer to Running the Criteria Maintenance Job for Expression Fields.