Creating Advanced Expressions

Top Previous Topic Next Topic  Print this topic

1. When working in the Insert Field Dialog or the Edit Field Dialog, select the Create expression button located in the Advanced section.

 

2. From the Create Expression Dialog, add an expression item by selecting from the available options located below the Expression Box. When you select an option, a menu will be displayed for you to choose from the required function. The selected function will be automatically inserted in the Expression Box.

 

3. Select the item(s) from the data tree that you would like to use for the arguments. Upon doing so, you will be provided with two options indicated with plus signs in the expression options list: Insert the selected path from the Data tree or Insert only the selected element. Depending upon what type of expression you are using, by selecting either of these options you will notice that your selected item in the Data Tree will now be inserted into the Expression Box.

 

4. Select the green check mark to the right of the Expression Box to validate the expression that you have created. If your expression is not valid, the Publisher will display an error message with details about what the problem is regarding the expression. If successful, you will receive a message stating so.

 

5. Once your Expression is validated select Insert and you will be returned to the Design Surface where your field is now inserted.

 

6. It is recommended that you preview your output to ensure that your expression is working exactly as you intended.

 

Examples

Combining Tow Data Points - Learn how to use the concatenate function.

Finding the Sum of Multiple Data Points - Lean how to use the functions to calculate the sum.