Adding a Nested Formula
You can create nested formulas (formulas inserted within formulas) by copying and pasting the syntax of one formula into another one or by selecting one of the formula columns the same way you do to insert a regular dataset column into a formula’s syntax.
To add a nested formula:
|
1.
|
In the Insert Columns list, locate the formula column you want to insert and add it in the parentheses like you would with any other data column. |
|
2.
|
Add any additional parameters that are needed for the function. |
|
3.
|
Test the formula by clicking the Test button. |
|
4.
|
Enter a name in the Formula Name field. |