Refer to the exhibit.
A business analyst must analyze sales using an existing sales order app.
✑ The Orders table in the app was added from a QVD file using the data manager
✑ The Orders table in the app and the QVD do NOT contain a SalesAmount field
✑ SalesAmount can be calculated by multiplying the Quantity and UnitPrice
How should the business analyst add a SalesAmount field into the Orders table?
To create a SalesAmount field in the Orders table, you should use the data manager to add a calculated field named SalesAmount with the expression UnitPrice * Quantity. This method allows you to calculate the SalesAmount directly within the app without the need to modify the original QVD file or incorrectly apply an aggregation function.
A) Incorrect because you don't need the SUM() function as you are effecting line items from the QVD not aggregating. B) Incorrect because you can't add columns in the data model viewer page. C) Correct because you can use the data manger to add a new field D) Incorrect because you cant edit the QVD as you are a consumer of the QVD not the creator of it in this situation. this would be a valid solution however if you had access to the QVD builder script.
C. In the data manager, add a calculated field named SalesAmount with the expression UnitPrice * Quantity