Using Operators in Formulas

Web Intelligence provides many operators for you to use in your formulas. An operator allows you to perform mathematical operations, test for conditions such as whether one value is less than another, and link multiple conditional clauses together using logical operators such as AND and OR.

Mathematical Operators

Mathematical operators allow you to perform the following basic mathematical calculations:

image

Conditional Operators

Conditional operators allow you to perform comparisons between two components of a formula, returning a true or false value. Conditional operators are most commonly used in if-then-else logic, such ...

Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.