**Introduction**

**Properties **are inputs for Items and Assemblies. This is the first step before creating an Item or an Assembly.

After you apply properties in Item or Assembly, they'll be transformed into a column in the Items report.

**How to create the "Formula" property **

Go to the Assemblies Database page and open the Properties tab there

Press the

**New button ->**select the**Formula type**Set a name for your property

*(the field is mandatory)**The name must be unique*Specify the

**Unit***Unit can be further changed when adding it to Item and to Assembly, and when applying it to Measurements*Specify the

**Group***(the field is mandatory)*

To create a group, perform the following steps:There're

**4 types of values**available for working with formulas:**MEASURES**— data from your Takeoff (area, perimeter, length, etc.):— a number of Count tool points. All other measurements (polygon, rectangle and polyline) have Count equal to 1`MeasuredCount`

— length of a polyline`MeasuredLength`

— area of a polygon`MeasuredArea`

— perimeter of a polygon`MeasuredPerimeter`

— width of a rectangle created using the tools`MeasuredWidth`

*Rectangle 2, Rectangle 3*— height of a rectangle created using the tools`MeasuredHeight`

*Rectangle 2, Rectangle 3***FUNCTIONS**— check below the list of functions available:— returns the absolute value of a number, which is the number without its sign`ABS`

— returns true if all of the provided arguments are logically true, and false if any of the provided arguments are logically false`AND`

— returns the numerical average value in a dataset, ignoring text`AVERAGE`

—`CHOOSE`

— returns the concatenation of two values. Equivalent to the `&` operator`CONCAT`

— returns the cosine of an angle provided in radians`COS`

— returns the cotangent of an angle provided in radians`COT`

— returns the number of numeric values in a dataset`COUNT`

— converts an angle value in radians to degrees`DEGREES`

— returns the position at which a string is first found within text, case-sensitive`FIND`

— returns one value if a logical expression is `TRUE` and another if it is `FALSE``IF`

— returns a substring from the beginning of a specified string`LEFT`

— returns the length of a string`LEN`

—`MAX`

returns the median value in a numeric dataset`MEDIAN`

—— returns a segment of a string`MID`

— returns the minimum value in a numeric dataset`MIN`

— returns the opposite of a logical value - `NOT(TRUE)` returns `FALSE`; `NOT(FALSE)` returns `TRUE``NOT`

— returns true if any of the provided arguments are logically true, and false if all of the provided arguments are logically false`OR`

— returns the value of pi to 9 decimal places`PI`

— returns a number raised to a power`POWER`

converts an angle value in degrees to radians`RADIANS`

—— returns a substring from the end of a specified string`RIGHT`

—`ROUND`

—`ROUNDDOWN`

—`ROUNDUP`

—`SIN`

—`SQRT`

—`SWITCH`

—`TAN`

**PROPERTY**— list of all properties used in your database

📝**Note!**

Start typing in the text box to find what you need.You can also scroll up and down using the arrow keys. To insert the value you selected into the formula, click

or`Tab`

`Enter`

**VALUES**—**numeric values eg 2.75.****Note!**Numeric values will not be automatically converted when used in a formula.

Insert

**Formula***(the field is optional)**Formula can be further changed when adding it to Item and to Assembly, and when applying it to Measurements or Folders*Hit the

**Create button**to create a new propertyOnce the Property has been created, it'll appear in the Properties tab inside the group you've specified when creating a property