Microsoft PL-200 Question Answer
You are configuring the Invoice table in Datavetse for a billing application. Each invoice has multiple associated invoice line records. You need to display columns with the following values:
• Total Handling Cost that is the sum of the Handling Cost column on all related invoice lines
• Remaining Balance that subtracts the Payment Received column from the Total Amount column
You need to implement the Total Freight and Remaining Balance columns on the Invoice table.
Which column types should you use? To answer, move the appropriate column types to the correct calculations. You may use each column type once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.



