Virtual Calculated Field in Table Record

You can display a calculated value by operating on more than one field in any label, literal, textbox or dropdown list control.  For example, the extended price of an order can be displayed in a literal control using this formula for the ‘Initialize when showing record’ event:

= FORMAT(PARSEDECIMAL(Order_DetailsRecordControl.UnitPrice.Text) * PARSEDECIMAL(Order_DetailsRecordControl.Quantity.Text),"c")

Because the values of the UnitPrice and Quantity field value controls are text, we parse them to find their decimal values and then calculate the product.  The FORMAT function is used to display the product as a currency.

See Also

Common Formula Examples