Adding functions
Functions are predefined set of commands that perform a specific operation on data.
1. Add a report or open (edit) an existing report.
2. Click the Add expression button to open the Expression builder window.
3. In the Functions section, double-click the desired function.
The function is added to the Expression section. Possibly the function needs parameters.
4. When the function needs parameters (as specified in the explanation and in General functions, Date-time functions, String functions, Numeric functions), place the cursor between the brackets behind the function at the correct parameter position.
5. It is possible to populate the parameter now either by:
◦ Double-clicking the field in the Available fields section. If this field is a reference to another business object, the fields of this business object are shown.
◦ Typing in text manually into the Expression section.
6. Complete all parameters as described above
Data is now added to the Expression section, between the brackets of the function.
The expression has now been completed as you can see from the following (StrToNumber function) example.
7. In the Expression section, click the Check button.
Planon will now check whether the expression you have built is correct.
8. Click OK to save the expression and to close the Expression builder window.
You will now return to the Report definitions and settings window. Your expression has been added to the Selected fields section.
9. In the Selected fields section, select the expression you have just created.
10. In the Settings section, specify the required field settings.
For more information on field settings, refer to, Making field settings.
11. View the result in the print preview of the report.
If the report looks fine you can print or save it.