What expression would you use to create a calculated field that determines the discount price by subtracting 10 from the value in the Price field?
A) [DiscountPrice]: Price-10
B) [Price]-10=DiscountPrice
C) DiscountPrice: [Price]-10
D) DiscountPrice: [Price]*10

Question

Quizplus · Accepted Answer

The correct syntax for creating a calculated field that determines the discount price by subtracting 10 from the value in the Price field is the one presented in option C: DiscountPrice: [Price]-10. This expression creates a new field called DiscountPrice and calculates its value based on the Price field minus 10. Options A and B are incorrect because the syntax is not correct, as the formula should be written as [NewField]: [Expression]. Option D multiplies the Price field by 10, which does not calculate the discount price.

What Expression Would You Use to Create a Calculated Field