Question

A sales team stores quotes in a Dataverse table. Each row has a 'Unit Price' column and a 'Quantity' column. The team needs a 'Line Total' column that automatically multiplies these two values whenever a row is created or edited, without requiring anyone to enter it manually or run a separate flow. What is the most appropriate way to configure the 'Line Total' column?

Accepted Answer

Create a formula (calculated) column that uses Power Fx to multiply Unit Price by Quantity

Answer

Create a standard text column and instruct users to type the total each time

Answer

Create a lookup column that references the Unit Price and Quantity columns

Answer

Create a choice column listing common total amounts for users to select