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.
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)- A12% (2)
- B88% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.