This article is for Cloud. Visit Data Center

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

When mapping variables within 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.

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

Formula editor with a variable mapped to another formula

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

Using formulas as variables, you can create very powerful, highly customized formulas - but managing all those sub-formulas can get tricky. An alternative approach is to build each sub-formula as a separate column, and add them to your formula using columns as variables.

  • No labels