**Cross-table formula**is a hit feature of Bitable that enables data references across tables within the same Bitable file.

**Formula**.

**Grid name**:

**Table 1**

**Field/column**:

**Column 1**(Multiline field),

**data reference**(Formula field)

**Existing data**: "1" in the first row, "2" in the second row, "3" in the third row, and so on.

- •
**Reference a column in the same table**

**data reference**column. In the pop-up formula pane, select

**Column 1**to reference data in this column.

- •
**Reference a dataset in the same table**

**Table 1**>

**Column 1**to reference all the data in this column into this cell.

**Formula**: [Table 1].[Column 1]

- •
**Reference a dataset across tables**

**Table 2**in the formula pane. Then click

**Table 2 Column 2**to reference all the data in this column into this cell.

- •
**Scenario: Calculate percentages**

*Note**: The field type for this column should be*

*Number**for calculations.*

- •
**Formula 1**: [Column 1]/SUM([Table 1].[Column 1])

- •
**Formula 2**: Write a formula with the chaining syntax directly: [Column 1]/[Table 1].[Column 1].SUM()

*Tips**: Double-click on the column header or click the*

*down arrow**icon to change the field type.*

**Scenario**: In budget management, you can use the formulas above to work out the share of cost for each purchased item relative to the total spending.

**LOOKUP**function to precisely find and match values across tables. We'll illustrate the use of this function in a real-world scenario: Order management.

- •
**Match values across tables**

**LOOKUP(Person in charge, sales record (Order).Person in charge,Sales record (Order).Order record)**

**[Person in charge]**column to match the

**[Pperson in charge] column in the [Sales record(Order)] grid**. After a match is found, display

**[order information]**).

- •
**Sum up data**

**LOOKUP([Person in charge],[Sales record].[Person in charge],[Sales record (Order)].[Sales]).SUM()**

- •
**Count data entries**

**LOOKUP([Person in charge],[Sales record (Order)].[Person in charge],[Sales record (order)].[Order record]).COUNTA()**

- •
**Find the maximum value**

**LOOKUP([Person in charge],[Sales order (order)].[Person in charge],[Sales order (Order)].[Sales]).MAX()**