SAP 7090310 Ficha de datos descargar pdf (Pagina 419)

100

101

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.

2011-05-16419

Using Formulas

1 2 ... 414 415 416 417 418 419 420 421 422 423 424 ... 705 706

Comentarios a estos manuales

Vikixwk 04 Jan 2024 | 13:20:14

urenrjrjkvnm

Viktorihon 14 Jan 2024 | 00:44:53

Cinema

SAP 7090310 Ficha de datos Pagina 419

Comentarios a estos manuales