Data table with four columns, need in the data window can query each employee in the current production and AB difference and proportion, how to design? Give a good idea, very flash, thanks a lot!!!

CodePudding user response:

The

refer to the original poster zt9476715 response:

Data table with four columns, need in the data window can query each employee in the current production and AB difference and proportion, how to design? Give a good idea, very flash, thanks a lot!!!

Direct writing SQL in data window or expression might be the problem, suggest you build a pseudo column, write a cycle in our program to implement

First find the current employees in a period, then calculate on business value, and then written to the data in the window

CodePudding user response:

Establish a storage process to establish the data window, according to the data window fields to create a temporary table, then use the cursor to fetch the data from the table, calculate the value, and then inserted into a temporary table, then select a temporary table, so much faster than the data window query speed, also easy to modify,

CodePudding user response:

Give you an idea you go back under test
Sort data according to the researchers
New computed column "A" poor calculating formula for
A number of product - A product number [1]

CodePudding user response:

The

refer to the original poster zt9476715 response:

Data table with four columns, need in the data window can query each employee in the current production and AB difference and proportion, how to design? Give a good idea, very flash, thanks a lot!!!

Don't forget to judge whether A number [1] free value

CodePudding user response:

The

reference 3 floor baopeng82 response:

give you an idea you back to test the
Sort data according to the researchers
New computed column "A" poor calculating formula for
A number of the product - A product [1]

This is just dealing with a person's way of thinking, if it is all the people there will be a problem