Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

When mapping variables within creating a formula, you can choose to map a variable to another formula. This allows you to set the values for that variable based on a separate calculation. These sub-formulas can also have variables, which can also be mapped to formulas.it is sometimes necessary to create variables that are based on separate calculations, rather than issue fields or other attributes.

There are a few ways to do this in Structure formulas:

1. Define a Local Variable

For simple calculations, it is often easiest to define a local variable within your formula. See Local Variables.

2. Use an existing formula column

To map a variable to an existing formula column, see Columns as Variables.

3. Create a new formula

To map a variable to another formula, simply select Formula in the Source selection drop-downa new formula, in the variable’s Source dropdown, select Formula. A new Formula field editor will appear for the variable.

Formula editor with a variable mapped to another formulaImage Removed

info These “formulas within formulas” can also contain variables, which can be mapped to yet more formulas.

...

Variables in a sub-formula are not the same as the variables declared by a parent formula; variables do not overwrite each other, even if they have the same name

...

Columns as Variables

...

.