SAP
C_BOCR_11 · Question #156
You create a Commission report for the Sales Manager. It is to be prepared at the end of each week and must list all active salespeople, whether or not they actually earned a commission for the week.
The correct answer is B. (ISNULL( {Employee.Commission}) OR {Employee.Commission} >= 0.00 AND {Employee.Week#} =. See the full explanation below for the reasoning.
Question
You create a Commission report for the Sales Manager. It is to be prepared at the end of each week and must list all active salespeople, whether or not they actually earned a commission for the week. You do not want negative commission amounts to be included in the report. Which record selection formula should you use for the report?
Options
- A(ISNULL( {Employee.Commission}) OR {Employee.Commission} >= 0.00 OR {Employee.Week#} = 35.00
- B(ISNULL( {Employee.Commission}) OR {Employee.Commission} >= 0.00 AND {Employee.Week#} =
- C{Employee.Commission} >= 0.00 AND {Employee.Week#} = 35.00
- D{Employee.Commission} >= 0.00 AND ISNULL( {Employee.Commission}) AND {Employee.Week#} =
How the community answered
(39 responses)- A10% (4)
- B72% (28)
- C3% (1)
- D15% (6)
Community Discussion
No community discussion yet for this question.