nerdexam
SAP

C_BOWI_40 · Question #131

You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?

The correct answer is B. =If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales. This question tests correct syntax for the If/ElseIf/Then conditional formula in SAP BusinessObjects Web Intelligence.

Using Formulas and Variables

Question

You are creating a "Target Revenue Based on Required % Growth" variable that is represented by 5% revenue growth for California and 18% for Massachusetts. Which If() function statement is valid?

Options

  • A=If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales
  • B=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales
  • C=If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales
  • D=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales

How the community answered

(35 responses)
  • A
    14% (5)
  • B
    71% (25)
  • C
    3% (1)
  • D
    11% (4)

Why each option

This question tests correct syntax for the If/ElseIf/Then conditional formula in SAP BusinessObjects Web Intelligence.

A=If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales

Using 'Else[State]' instead of 'ElseIf[State]' is invalid syntax; the ElseIf keyword is required when adding another conditional branch.

B=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [SalesCorrect

The correct Web Intelligence formula syntax requires 'If ... Then ... ElseIf ... Then ... Else ...' with the 'Then' keyword following each condition, and square brackets around object names, which choice B correctly implements for both the California and Massachusetts branches.

C=If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales

Replacing 'Then' with a semicolon after the first condition is not valid Web Intelligence formula syntax; the 'Then' keyword is mandatory.

D=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales

Choice D appears syntactically the same as B in abbreviated form; if the full text differed it would contain a syntax error such as a missing 'Then' or incorrect spacing around the ElseIf clause.

Concept tested: Web Intelligence If ElseIf Then conditional formula syntax

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/1fd2fc7d3a6e45c982b82e75ca8e0c6f/46d90be16e041014910eff47ad148e3b.html

Topics

#If ElseIf syntax#conditional formula#variable creation#formula syntax

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice