nerdexam
SAP

C_BOWI_40 · Question #77

Which three statements about the If() function are correct?

The correct answer is B. The function can be used to create a variable. C. The function can contain an aggregate function. D. Then and Else keywords can be used within the function instead of the semicolon. The If() function in Web Intelligence supports flexible syntax including Then/Else keywords, can wrap aggregate functions, and can serve as the basis for a variable definition.

Using Formulas and Variables

Question

Which three statements about the If() function are correct?

Options

  • AValues within the function must be in quotes.
  • BThe function can be used to create a variable.
  • CThe function can contain an aggregate function.
  • DThen and Else keywords can be used within the function instead of the semicolon.

How the community answered

(17 responses)
  • A
    12% (2)
  • B
    88% (15)

Why each option

The If() function in Web Intelligence supports flexible syntax including Then/Else keywords, can wrap aggregate functions, and can serve as the basis for a variable definition.

AValues within the function must be in quotes.

Quotes are only required around string literal values; numeric values, date literals using specific functions, and object references do not require quotes, so the rule does not apply to all values universally.

BThe function can be used to create a variable.Correct

The If() function can be used as the formula body when creating a variable in the Variable Editor, allowing conditional logic to be stored as a reusable named object in the document.

CThe function can contain an aggregate function.Correct

Aggregate functions such as Sum() or Count() can be nested inside an If() function, enabling conditional aggregation - for example, summing values only when a condition is met.

DThen and Else keywords can be used within the function instead of the semicolon.Correct

Web Intelligence supports both the semicolon-separated syntax and the Then/Else keyword syntax within the If() function, giving report authors two equivalent ways to express conditional logic.

Concept tested: Web Intelligence If() function syntax and usage

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/12e2b6ba7b7a4b99aa21e046cd54c437/46e39c2576fb403ee10000000a114084.html

Topics

#If() function#aggregate functions#Then/Else keywords#variable creation

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice