Create a calculated field that does not exist in the table by using a calculation formual.

Step 1. Add a Calculated Field

Add a calculated field using the columns of the table.

1. Right-click on the table to create a calculated field and select [Calculated Field] menu.
   
   
   
   
2. In the Calculated field window, click the [+] Add button to add a calculated field.
   
   
   
   
3. Set the [Name] and [Category] of the added field.
   
   
   
   

4. Double-click the field to be calculated and add it, write the formula, and then click the [OK] button to create the calculated field.
   
   

   

   ([auddemo.public.sales_performance_en.revenue_price] - [auddemo.public.sales_performance_en.revenue_cost]) * [auddemo.public.sales_performance_en.quantity]

   
   

   The formula for the calculated field should be written according to the syntax of the connected database.

   
   

5. Confirm that the calculated field has been added to the table list.
   
   

Step 2. Define Calculated Field Properties

Modify the properties of the calculated field.

1. Right-click on the field to be set in the i-META item and select the [Property] menu.
   
   
2. Change the [DefaultFormat] of the [Total Sales Profit] field.
   
   • DefaultFormat : #,##0