How do I calculate across forms? For example, calculate inventory information through purchase information and shipment information

When you seefunction cannot use multi-cubeWhen an error is reported, you are successful.

The meaning of this sentence is: currently, YIDA does not support the use of formulas across tables (that is, after multiple tables are associated, formulas cannot be used for calculation. We are in the optimization plan, but the time will be relatively low)

1. Scenario

For our purchase, sale and storage, we need to calculate the inventory values of the purchase table and the shipment table and display them.

Pay special attention here. There is a misunderstanding. The design method of YIDA is more to solve the problem through "intermediate table", and the report is more used for display. Therefore, do not use multi-table Association to try to solve this problem. If you must use a report to complete it, you need to prepare data, integrate multiple tables into one, and then configure it in the report.

1.1 purchase, sale and deposit

For the convenience of demonstration, we simply demonstrate the purchase, sale and storage scenario of the next simple version.

1.2 Logic

Purchase table

Purchaser	Purchase details		Purchase time
Nine Gods	Apple	1000	2021-03-08 16:30:03
	Orange	100
New armor	Apple	100	2021-03-09: 30:46
	Orange	10

Shipping table

Customer	Purchase details		Purchase time
Customer A	Apple	10	2021-03-08 16:35:03
	Orange	5
Customer B	Apple	1	2021-03-09 16:32:46
	Orange	2

The following table is obtained through the above table.

Inventory statement

Apple	1089
Orange	103

1.3 Video demo

1.3.1 demonstration of the solution calculated through the intermediate table

Intermediate tables can be understood as tables that are specially used to store basic data and integrate data, and can be used as data transfer stations.

Advantages, complex configuration

Disadvantages, real-time updates, large data volume may cause lag

Implementation logic:

1. Update inventory statement when the purchase table changes
2. Update inventory statement when shipping table changes

此处为语雀视频卡片，点击链接查看：如何通过中间表完成跨表计算.mov

1.3.2 through the solution demonstration of "data preparation" (The data preparation function is only provided in VIP version)

Advantages: simple configuration

Disadvantages, update non-real-time, suitable for large data volume, more than 5W operations

Video to be supplemented

YIDA in order to better optimize the content and quality of YIDA user manual, it takes you 3-5 minutes to fill in the document feedback questionnaire. The document feedback questionnaire is submitted anonymously, and the questionnaire information is only used for YIDA document experience feedback collection. Thank you for your support for YIDA!

Click here to fill in the questionnaire

-------------------- Get the latest information YIDA, welcome to follow US--------------------