계산 수식을 활용하여 테이블에 없는 계산 필드를 생성합니다Create a calculated field that does not exist in the table by using a calculation formula.

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.
   
   Image Added
   
   
2. In the Calculated field window, click the [+] Add button to add a calculated field.
   
   Image Added
   
   
3. Set the [Name] and [Category] of the added field.
   
   Image Added
   
   

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.
   
   

   Image Added

   코드 블럭
   language sql title 총 매출 이익Gross Profit collapse true
   ([edusampleauddemo.public.sales_매출실적.매출단가]-[edusampleperformance_en.revenue_price] - [auddemo.public.sales_매출실적.매출원가performance_en.revenue_cost]) * [edusampleauddemo.public.sales_매출실적performance_en.매출수량quantity]

   
   

   참고사항
   title 참고 : 계산 필드 수식 작성 방법
   계산 필드의 수식은 연결된 DB의 문법에 맞춰 작성합니다.

   테이블 목록에 계산 필드가 추가된 것을 확인합니다.
   Image Removed

Step 2. 계산 필드 속성 정의하기

계산 필드의 속성을 변경합니다.

...

• DefaultFormat : {0:N0}

...

추가적인 계산 필드 활용 관련 내용은 하단의 링크를 클릭해주세요.

...

1. Note : How to Write a Calculated Field Formula

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

   
   

2. Confirm that the calculated field has been added to the table list.
   
   Image Added

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
   
   Image Added