Some New Math Functions that are fun to use:

Alt Name:

Use the alt name if your item name is going to change. The alt name will give you the ability to keep a constant name regardless of what it is your item name is.

if you would like to set an Alt name to refer to click on the top right corner or the property name you would like to connect to and click on the gear and select Alt Name. Then give the property a new name and close. When you use the sibling code [./New Name/Name] see below:

Sibling Property:

[./Property/Another Property] You can grab information from another sibling by using [./] The Alt Name will be very useful for this.

Pi*Radius Squared:  

If you would like to calculate the area of a pipe you can use this formula. So, in the case of pipe area for displacement at could look like this-  

pi*(([Pipe Size]/12)/2)^2 

a 24” pipe for be 24/12 or 2, then 2/2 is 1. ….1squared is 1 and then times 3.145. So, a 24” pipe would have a surface are of pi.

^2: 

This will square any property. ^3  will cube and so on, you can use fractions if you like.

If you multiply a difficulty by ^1.1 by a wall height it won’t just add 10 percent of every foot it actual compounds. 1.1 for 1’ tall wall, 1.21 for a 2’ tall wall, 1.331 for a 3’ tall wall and so on.

You can also use decimals in the Root function ^.89

? and :

These two symbols will help you shorten your if/then statements. In the case below the formula is stating that if the Pipe size is. Equal to 4, then the answer is 1

The : continues the formula to if the pipe size is equal to 6, then the answer is 1.4: the (?) represents the answer if 4 is correct then the  will keep looking if it is not…

The following expression lists the pipe sizes and all of the answers for trench width in feet up to 24” pipe, but after the final statement the colon (:)after the last: the answer will return to 0 (see below)

[Pipe Size] == 4 ? 1 : [Pipe Size] == 6 ? 1.4 : [Pipe Size] ==8 ? 1.5:  [Pipe Size]== 10 ? 2:[Pipe Size] == 12? 2 : [Pipe Size] == 18 ? 2.5 : [Pipe Size] ==24 ? 3:0

[^] Caret: When the ^ is in a bracket [^] it will look to grab parent and or grandparent properties.

The following Text with tags will grab the folder name of a property, it replaces the ../ or the ../../ as needed.     [^Folder/Name] 

Updated on: 29/04/2026