SAP Business Objects Web Intelligence (C_BOWI_41) Test 3

Question : 13 of 20

Marks: +1, -0

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?

=If[State] = "California" Then [Sales revenue] * 1.05 Else[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
=If[State] = "California" ; [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue]
=If[State] = "California" Then [Sales revenue] * 1.05 ElseIf[State] = "Massachusetts" Then [Sales revenue] * 1.18 Else [Sales revenue] End

Validate

Go to Question:

Prev Question

Next Question