Using Functions in Formulas

SAP BusinessObjects BI 4 Web Intelligence provides many functions for you to use in your formulas. A function is an operation that takes zero or more input parameter values and generates a single output value. For example, =Round(273.75;0) returns 274. In this example, the Round function takes two input parameters—the number to be rounded (273.75) and the number of decimal places to round the number to (0)—and returns the output value (274). Input parameters can be universe object variables, user-defined variables, numeric constants, or text literals.

Functions can be added to formulas by typing them directly into the Formula Editor or by selecting them from the list of available functions when using the Formula Editor. ...

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.