nerdexam
SAP

C_BOWI_40 · Question #90

A variable in your report contains the statement: =If[State] = "California" Then [Sales revenue] 1.05 Else If[State] = "Colorado" Then [Sales revenue] 1.1 Else If[State] InList ("DC";"Texas ") Then…

The correct answer is A. 1.00. The nested If-Else formula evaluates each state condition in sequence; because Florida does not match California, Colorado, DC, Texas, or Massachusetts, the formula falls through to the final Else branch and returns the sales revenue unchanged, applying an implicit rate of 1.00.

Using Formulas and Variables

Question

A variable in your report contains the statement:

=If[State] = "California" Then [Sales revenue]

  • 1.05 Else If[State] = "Colorado" Then [Sales revenue]
  • 1.1 Else If[State] InList ("DC";"Texas ") Then [Sales revenue]
  • 1.15 Else If[State] = "Massachusetts" Then [Sales revenue]
  • 1.18 Else [Sales revenue]

Sales revenue for Florida is $1,879,159. Which rate is applied to the Florida revenue by the formula?

Options

  • A1.00
  • B1.05
  • C1.10
  • D1.15
  • E1.18

How the community answered

(23 responses)
  • A
    74% (17)
  • C
    4% (1)
  • D
    9% (2)
  • E
    13% (3)

Why each option

The nested If-Else formula evaluates each state condition in sequence; because Florida does not match California, Colorado, DC, Texas, or Massachusetts, the formula falls through to the final Else branch and returns the sales revenue unchanged, applying an implicit rate of 1.00.

A1.00Correct

Florida does not satisfy any of the explicitly named state conditions in the formula. The final Else clause returns [Sales revenue] with no multiplier applied, which is mathematically equivalent to multiplying by 1.00, so the full $1,879,159 is returned as-is.

B1.05

The 1.05 multiplier is applied exclusively when [State] equals 'California'; Florida does not match this condition.

C1.10

The 1.10 multiplier is applied exclusively when [State] equals 'Colorado'; Florida does not match this condition.

D1.15

The 1.15 multiplier is applied only when [State] is in the list containing 'DC' and 'Texas' via the InList function; Florida is not in that list.

E1.18

The 1.18 multiplier is applied exclusively when [State] equals 'Massachusetts'; Florida does not match this condition.

Concept tested: Web Intelligence nested If-Else formula conditional logic evaluation

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/8c3f451ccb754f84b26be7f44b8af59e/46c73dc86e041014910aba7db0e91070.html

Topics

#If-Then-Else#formula evaluation#conditional logic#nested conditions

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice