SAP
C_BOCR_11 · Question #187
The Sales Department needs a Crystal report that shows total sales by day for the month and allows the report reader to view either a report listing all days in the month to date or a shorter report…
The correct answer is D. Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 10000. See the full explanation below for the reasoning.
Question
The Sales Department needs a Crystal report that shows total sales by day for the month and allows the report reader to view either a report listing all days in the month to date or a shorter report showing just the days when sales exceeded a bonus target of $10000. You decide to use report alerts to accomplish this. Which formula properly sets the alert condition?
Options
- ASum ({Orders.Order Date}, {Orders.Order Amount}, "daily") > 10000
- BIF Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 10000 THEN crCondition = "Enabled"
- CIF Sum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 10000 THEN AlertMessage = "Enabled"
- DSum ({Orders.Order Amount}, {Orders.Order Date}, "daily") > 10000
How the community answered
(24 responses)- A8% (2)
- B13% (3)
- C4% (1)
- D75% (18)
Community Discussion
No community discussion yet for this question.