# Equations in Tables and BOMs

You can specify calculations for equations using different methods:

- Use text strings for built-in column headings in a BOM to specify mathematical expressions. Use single quotation marks in the equation display (for example, 'ITEM NO.' or 'ITEM NO.'*'QTY.').
Built-in column headings for BOMs include Item No., Qty., and Part Number.
- Use custom properties in equations. When you select a custom property, it appears in single backward quotation marks in the equation display (for example, `Price`).
- Use the # symbol in front of a column heading item (for example, #'PART NUMBER'). This syntax ignores non-numeric text in the calculation. If you do not use this syntax and an item includes non-numeric characters, the value appears as 0.0.
- Type regular text strings that do not represent column headings in double-quotes (for example, "$").
- An IF function returns one value if a condition is true, and another value if the condition is false. Specify the IF function using semi-colons to delimit the outcomes for IF functions as follows:
`IF(test_condition; value_if_test_condition_true; value_if_test_condition_false)`

For example:

Equation:

`IF('DESCRIPTION'<>""; 'DESCRIPTION'; "-")`

Result:

DESCRIPTION value (if not empty) or "-".

You can use conditional operators for the test condition in an IF function:

Symbol Description Example = Equals 'Description' = "" (The description property is empty) > Is greater than 'Qty.' > 2 < Is less than `Length` < 2 <= Is less than or equal to >= Is greater than or equal to <> Is not equal to 'DESCRIPTION'<>"" (the description property is not empty) - Sum, Average, Count, Max, and Min operate on cell entries of the table. For example, Ave(A1,A5) displays the average of the entries of cells A1 and A5.
- You can use the colon syntax along with cell numbers to indicate operations on rows or columns. For example, SUM(A1:A5) gives the sum of the values from cells A1 through A5.
- You can use *, +, /, and -, for multiplication, addition, division, and subtraction, respectively.

Contents

**General Format Precision in Table Equations**

You can use the General Format precision option in table equations to specify precision, concatenate custom property values, and eliminate extra decimal zeros.

**Displaying the Sum of Column Cells in a Table**

You can populate a table cell with the sum of the preceding column cell values. For example, in a BOM, you can display the cost subtotal of a set of items.

**Totaling Column Cells in a Table**

You can populate the last table cell in a column with the sum of its preceding cell values. For example, in a BOM, you can display the total cost of a set of items.

**Defining Table Equations by Mathematical Operations on Custom Properties**

You can define table entries using mathematical operations on custom properties. In this BOM table example, multiply the value of the custom property Unit Cost with the component quantity to calculate the total cost.

**Combining Properties in Table Equations**

You can combine properties in table equations.

**Testing Conditions to Populate Tables**

You can use the logical

`IF`to populate table entries based on a test condition.**Table Equation Editor**

You can use the equation editor to include calculated quantities or simple logic in a table or BOM cell, or in a BOM column.

**Parent topic**Tables