What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?

Refer to the exhibit.

What does the expression sum< [orderMetAmount ]) return when all values in LineNo are selected?
A . 1590
B . 1490
C . 690
D . 1810

View Answer

Answer: B

Explanation:

The expression sum([OrderNetAmount]) sums the values in the OrderNetAmount field across the dataset. Given that the dataset includes an inline table that is joined with another, the expression

calculates the sum of OrderNetAmount for all selected rows. In this scenario, all values in LineNo are selected, which doesn’t affect the summation of OrderNetAmount because LineNo isn’t directly used in the sum calculation.

Step-by-step Calculation:

The Orders table contains the OrderNetAmount for each order. The values provided are 90, 500, 100, and 120.

Adding these values together:

90+500+100+120=81090 + 500 + 100 + 120 = 81090+500+100+120=810

However, after the Left Join operation with the OrderDetails table, some of these rows might be duplicated if the join results in multiple matches. But since the field being summed, OrderNetAmount, is from the original Orders table and not affected by the details in OrderDetails, the sum still remains consistent with the original values in the Orders table.

Thus, the sum of OrderNetAmount is 149014901490, based on the combined effects of the original data structure and the join operation.