nerdexam
SAP

C_BOWI_40 · Question #50

You are reviewing a report with the following statement in a variable: =If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer"…

The correct answer is D. They will not have a performance value assigned. This question tests understanding of logic gaps in WebI If/Then/Else variable formulas where certain value ranges are not covered by any defined condition.

Using Formulas and Variables

Question

You are reviewing a report with the following statement in a variable:

=If([Sales revenue] > 750000) Then "Top Performer" Else If([Sales revenue] Between (200000;650000)) Then "Average Performer" Else If ([Sales revenue] < 200000) Then "Low Performer" Which statement is true of the results produced by the statement for sales representatives with sales between 650,000 and 750,000?

Options

  • AThey will be Top Performers.
  • BThey will be Average Performers.
  • CThey will not be included in the report.
  • DThey will not have a performance value assigned.

How the community answered

(32 responses)
  • A
    9% (3)
  • B
    19% (6)
  • C
    3% (1)
  • D
    69% (22)

Why each option

This question tests understanding of logic gaps in WebI If/Then/Else variable formulas where certain value ranges are not covered by any defined condition.

AThey will be Top Performers.

The Top Performer condition requires Sales revenue strictly greater than 750,000, which excludes all values at or below 750,000.

BThey will be Average Performers.

The Average Performer condition uses Between(200000;650000), which only covers values up to 650,000 and does not include values between 650,001 and 750,000.

CThey will not be included in the report.

Records for these representatives are still returned and displayed in the report; they simply receive no performance label because none of the If conditions applies to their revenue range.

DThey will not have a performance value assigned.Correct

The three conditions cover values greater than 750,000, Between 200,000 and 650,000, and less than 200,000 - no branch covers the range from 650,001 to 749,999. Because no condition evaluates to true for this range, WebI returns a null value and no performance label is assigned to those representatives.

Concept tested: WebI If/Then/Else logic gaps in variable formulas

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/ad8e1cb39f564e3788e5b5b9d3d3df74/46cd4fb36e041014910eba7adeb4df22.html

Topics

#If Then Else#conditional logic#logic gaps#variable analysis

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOWI_40 Practice