User`s guide

Numbers
Example: 1, 2, 3.1416
Text
Example: "Quantity", ":", "your text"
Operators
Example: + (add), / (divide), -x (negate)
Operators are actions you can use in your formulas.
Functions
Example: Round (x), Trim (x)
Functions perform calculations such as average, sum, and count. All functions available are listed with
their arguments and are arranged by their use.
Custom functions
Example: cdFirstDayofMonth, cdStatutoryHolidays
Custom functions provide a way to share and reuse formula logic. They can be stored in the SAP
BusinessObjects Enterprise Repository and then added to a report. Once in the report, custom functions
can be used in the Formula Expert when creating formulas.
Control Structures
Example: "If" and "Select", "For" loops
Group field values
Example: Average (fld, condFld), Sum (fld, condFld, "condition")
Group field values summarize a group. For example, you could use group field values to find the
percentage of the grand total contributed by each group.
Other formulas
Example: {@GrossProfit}, {@QUOTA}
20.2.2 Formula syntax
Syntax rules are used to create correct formula. Some basic rules are:
• Enclose text strings in quotation marks.
• Enclose arguments in parentheses (where applicable).
• Referenced formulas are identified with a leading @ sign.
2012-03-14417
Using Formulas