Pricing tables are typically associated with Measurement Options but they can also be used directly in formulas to find value.*** Compatibility**: The pricing table is best edited using Chrome web browser. Firefox has a known double entry issue. In Firefox, double click on a cell before trying to enter a number. If you single click, you may find that entered digit is duplicated.

## Managing Pricing Tables #

You can create, edit, and delete pricing tables from the Pricing Table section as follows.

1. Go to **Pricing Table** Tab.

2. Click **Create Pricing Table**.

**Pricing Table Presets** #

**Return fixed value**:

This table will always return a fixed number to its associated measurement option or function. Primarily used when you want to use a measurement option for its inputs but don’t need to return any specific price. This is an easy way to associated a pricing table with a measurement option while not returning any specific pricing values. You will still be able to access user inputs through:

measurementoption.input1 and measurementoption.input2 variables.

**Price from Dimensions**:

This table returns a price from input dimensions, typically length and width. Because it includes two dimensions, you can price a product differently depending on the proportions of the dimensions. This table would typically output the unit area price of a product based on its dimensions.

Formula typically used: measurementoption

**Price from Quantity:**

Returns a unit price based on a quantity. Can be used to reduce the price of a product based on quantity. In a price calculation, this table is typically referenced as follows:

quantityprice_pt[ 1 , product_quantity ] * product_quantity

This will return a unit price and multiplying that by product_quantity will give the final price.

**Discount from Quantity:**

This table returns a percentage value that can be used as a discount. The discount increases as the quantity increases.

In a discount calculation, this table is typically referenced as follows:

<baseprice>*quantitydiscount_pt[ 1 , product_quantity ]

This will return a discount amount to reduce the main calculation price by.

**Price from Area and Quantity:**

This table returns a unit price based on area and quantity. Row 1 is the area and Column A is the quantity. The table returns a unit price and will typically be multiplied by product_quantity.

In a price calculation, this table is typically referenced as follows:

areaquantityprice_pt[ <measurementoption>.input1*<measurementoption>.input2 , product_quantity] * product_quantity

**Discount from Area and Quantity:**

This table returns a discount amount or percentage based on area and quantity. Row 1 is the area and Column A is the quantity.

In a discount calculation, this table is typically referenced as follows:

<baseprice>*areaquantitydiscount_pt[ <measurementoption>.input1*<measurementoption>.input2, product_quantity ]

This will return a discount amount to reduce the main calculation price by.

**Round a Number:**

This table will help you round a number up.

**Using Pricing Tables in Formulas and Calculations** #

**Using Pricing Tables in Formulas and Calculations**

Pricing tables can also be referenced in option formula and calculator calculation fields without an associated Measurement option.

You can insert a Pricing table function into a formula or calculation field from the Calculation Variables dropdown.

Pricing table variable references will be formatted as follows:**tableuniquename[ x , y ]**

Where…**tableuniquename**: The unique name of the pricing table.

**x:** The value for input 1. This will be used to find the correct **column** in the vlookup of your pricing table.

**y:** The value for input 2. This will be used to find the correct **row** in the vlookup of your pricing table.

**Examples**:

**Pricing tables**are referenced by their unique name and must be provided a value for input 1 and input 2 separated by a comma. You can use other variables to insert the values used in the pricing table formula.*Examples of how to use a pricing table:*- pricingtable[input1,input2]
- pricingtable[20,35]
- pricingtable[20,sauce]