I'm in the column of DW window summary has three computed columns, respectively is compute3, compute4, compute5, I use
STOCK_QTY=dw_3.object.com pute5 [1]
IN_PIRCE=dw_3.object.com pute4 [1]
SALE_PRICE=dw_3.object.com pute3 [1]
Value first obtain value is right after the two values are not accurate, please help me to look at problems where thank you

CodePudding user response:

Compute4, posted compute5 expressions, and should be used in expressions

CodePudding user response:

Long ll_cnt
Ll_cnt=dw_3. Rowcount ()

IN_PIRCE=dw_3.object.com pute4 [ll_cnt]
SALE_PRICE=dw_3.object.com pute3 [ll_cnt]

So try

CodePudding user response:

The sum (compute_2 for all) expression

CodePudding user response:

Expression of compute_2

You put the compute_2 expression into the compute_4 directly, don't quote compute_2 try