nerdexam
SAP

C_BOWI_40 · Question #22

Which character should you use to reset the result of the RunningSum( ) function for either a break or a section?

The correct answer is A. Semicolon (;). Tests knowledge of the parameter syntax used to specify a reset condition in the Web Intelligence RunningSum() function.

Using Formulas and Variables

Question

Which character should you use to reset the result of the RunningSum( ) function for either a break or a section?

Options

  • ASemicolon (;)
  • BPercent (%)
  • CUnderscore (_)
  • DComma (,)

How the community answered

(67 responses)
  • A
    94% (63)
  • B
    1% (1)
  • C
    1% (1)
  • D
    3% (2)

Why each option

Tests knowledge of the parameter syntax used to specify a reset condition in the Web Intelligence RunningSum() function.

ASemicolon (;)Correct

In Web Intelligence formula syntax, a semicolon (;) is used to separate function parameters, including the optional reset parameter in RunningSum(). To reset on a break or section, you append a semicolon followed by the reset keyword, such as RunningSum([Measure]; Break) or RunningSum([Measure]; Section).

BPercent (%)

The percent sign (%) has no role as a parameter separator or reset indicator in Web Intelligence function syntax.

CUnderscore (_)

The underscore character (_) is not a recognized separator or reset trigger in any Web Intelligence formula function.

DComma (,)

A comma (,) is not a valid argument separator in Web Intelligence formulas; the semicolon is the required separator.

Concept tested: RunningSum reset parameter syntax in Web Intelligence

Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/09382741016d40bda21f1c28edcf4660/46d8cc4e6e041014910aba7db0e91070.html

Topics

#RunningSum function#break reset#section reset#formula syntax

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice