nerdexam
SAP

C_BOCR_11 · Question #101

You create a Crystal report that shows customer names and locations. You use a linked sub report to display details of the orders placed so far this year by each customer. Each customer's total purcha

The correct answer is A. Shared currencyVar cLYS; (Sum ({Orders.Order Amount}) ?cLYS)/cLYS;. See the full explanation below for the reasoning.

Question

You create a Crystal report that shows customer names and locations. You use a linked sub report to display details of the orders placed so far this year by each customer. Each customer's total purchases for last year are calculated and stored in the main report and retrieved by the sub report. The sub report must calculate the percentage increase or decrease in orders received this year as compared to each customer's purchases made last year. Which formula should you use to accomplish this?

Options

  • AShared currencyVar cLYS; (Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
  • BShared currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/ Sum ({Orders.Order
  • CGlobal currencyVar cLYS(Sum ({Orders.Order Amount}) ?cLYS)/cLYS;
  • DcurrencyVar cLYS; (cLYS - Sum ({Orders.Order Amount}))/ Sum ({Orders.Order Amount});

How the community answered

(28 responses)
  • A
    79% (22)
  • B
    4% (1)
  • C
    14% (4)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full C_BOCR_11 Practice