Pricing Tables

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 #

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]