Help documentation

Select the Formula radio button

Enter the formula to be used in setting the property value.

You will need to enclose in quotes any property name that includes spaces or arithmetic symbols (such as + or -).

For example if the property name is: Estimate - initial; then you would need to enter "Estimate - initial" or 'Estimate - initial'.

Formulas can reference the following:

• Any numeric, aggregate or date property that is common to all of the Card Types that you want the formula property to apply to
• Any numeric constant e.g. 5, 1.25, and so on

Formulas may not reference the following:

• Date constants, so you cannot hard-code a date as part of a formula
• Card properties which are not numeric or date based
• Card properties which are not available to all of the selected card types
• Other formula properties
• Project level variables

You can use the following arithmetic operators

• / division
• * multiplication
• + addition
• - subtraction
• operator precedence is /, *, +, - in this sequence
• you can use parenthesis ( ) to construct more complex expressions, e.g.:

  ((a + b) * (c + d)) / (e + f)

You might want to take a look at some examples.

Select whether or not to replace any (not set) numeric property values with zero.

This option allows you to specify how numeric property values that are (not set) will affect the calculated value of the formula. By default, if the value of any property within a formula is (not set) then the result of the formula calculation will be (not set). You can change this behavior to replace (not set) values with zero. See examples of how this option affects formula results to learn more about this option.

Select which card types the formula property should apply to

Click on the Create property link to save the formula property