Products, product options and quote subtotals can have dynamic pricing and quantity that is calculated based on any formula using any proposal, opportunity, product, account numeric or other option fields (including custom fields).
PRODUCT CALCULATED PRICE
To create a product with dynamic, calculated pricing, select the Calculated Price option by clicking the down arrow symbol next to the price field when creating a new product.
You can then define a pricing formula using any standard or custom numeric fields associated with the proposal or account. Simply click the down arrow in the formula box and select a variable to insert into your formula. It will be displayed with { } curly brackets. Standard mathematical symbols can be used: + for addition, - for subtraction, * for multiplication, / for division, ^ for exponents, and ( ) for grouping of operations.
In addition to account, proposal, product and opportunity fields, the Product Base Cost and Original Price (before options, price lists and volume pricing) is available to use as a variable in the formula.
You can edit this formula at any time on the product overview page by clicking the pencil icon in the upper right of the product basic information widget.
OPTION CALCULATED QTY, COST, PRICE, DISCOUNT
You can also use formulas and variables to calculate product option qty, cost, discount and price.
For each product option type, you can select the qty, discount, price and cost offset calculation method. Select Formula if you want the option qty, cost, discount or price to be calculated using a formula.
You will then be able to use any account, product, proposal, opportunity, or other option numeric field and the base product cost and original price to create a formula to calculate the product option qty, cost or price. Note that there is an example formula included in each field by default. You can modify this to anything you want. The example formula is only there for demonstration purposes.
SUBTOTAL FIELD CALCULATED PRICE
You can also use formulas to calculate quote subtotal fields, like shipping, tax, additional discount, or any other custom subtotal field that you create. In the quote settings, select the formula option for the field you want to use a calculation for.
SUM FUNCTION
In addition to the standard numeric operations, you can use the sum function in formulas for Subtotal Fields and also in Formulas variables in text elements on the proposal itself.
The sum function cannot currently be used in formulas for QTY, Price, Cost or Discount within options.
You can use the sum function in Calculated Product Pricing:
The format of the sum function is:
SUM(<expression>,<group_id>,<conditions>)
SUM({product_cost})
SUM({product_cost},"Quote Table 1")
SUM({product_cost},"Quote Table 1",{product_supplier}="Test Supplier")
SUM({product_cost},"Quote Table 1",{product_supplier}="Test Supplier" OR {product_category} IN ["Cat 1","Cat 2"])
The group_id is optional and should only be used if you have more than one quote table on a proposal.
You can use AND, OR, and IN for multiple conditions.
When you start typing Sum( in a formula input box, the variable list will dynamically change to include Line Item fields that are not normally displayed as variables and can only be used in the Sum function.