Create formulas

Tekla EPM
2021
Tekla EPM Tekla EPM GO

Create formulas

In the Formula dialog box, you can create formulas that Tekla EPM uses to calculate values. For example, you can create a formula to define the cost of an estimate extra, or to define the size of an angle used in a parametric assembly. You can access the Formula dialog box by clicking the Formula button on the right side of a field.

The formula functions allow you to add the following things to the formula:
  • Standard Variables: the properties of a material item.

  • Additional Variables: any previously added variables related to the parametric assembly or the estimate extra.

  • IF / THEN / ELSE / ENDIF statements

  • The CEILING, FLOOR, and ROUND rounding functions.

    The CEILING function always rounds up, the FLOOR function always rounds down, and the ROUND function rounds up at half and down by less than half.

  • Several trigonometry functions, such as SIN, COS, and HYP.

Example formula: Calculate the cost of an estimate extra

In this example, we want the estimate extra to add a cost of $100 if the length of the item is less than or equal to 40'. If the length is greater than 40', the added cost should be $150.

In this case, we need the following formula:

IF ([Length] <= 40') THEN (100) ELSE (150) ENDIF

  1. In the Estimate Extra dialog box, select the Cost Expression option, and click Formula.

  2. In the Formula dialog box, click the IF / THEN / ELSE / ENDIF button.

  3. Go to the parenthesis after IF.

  4. In the Additional Variables list, select Length.

  5. Click Add Variable.

    [Length] appears inside the parenthesis after IF.

  6. Enter a space after [Length].

  7. After the space, type <=40'

  8. Go to the parenthesis after THEN.

  9. Type 100

  10. Go to the parenthesis after ELSE.

  11. Type 150

    The formula is now ready.

  12. Click OK to close the Formula dialog box and use the formula in the estimate extra.

Was this helpful?
Previous
Next