SAP
C_DS_42 · Question #38
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables. Use the sum function to calculate the…
The correct answer is A. To map the ORDERID column from the input schema to the same field in the output schema, B. In the output schema, right click ORDERID and choose New output column. D. Choose Insert Below. See the full explanation below for the reasoning.
Question
You must calculate the total value of all orders, including their discounts, for reporting purposes. Currently these details are found in different tables. Use the sum function to calculate the total value of orders in the Order_Details table. How to in the Query transform, create a new output column TOTAL_VALUE , which will hold the new calculation?
Options
- ATo map the ORDERID column from the input schema to the same field in the output schema,
- BIn the output schema, right click ORDERID and choose New output column.
- CChoose the Where tab or the From tab.
- DChoose Insert Below.
How the community answered
(52 responses)- A81% (42)
- C19% (10)
Community Discussion
No community discussion yet for this question.