I have a program, need to use the formula to calculate the archive, formulas are set according to the data in the database, in the archive when I'm taking out formula, and then assigned to computational domain, and from the result of the calculation domain in calculation, but when I was single assignment formula is ok, but when the archive circulation to paraphrase formula, would be an Error, when I was in special assignment formula was written dw_3.object.com pute_2. Expression=gs, at the time of assignment of archive circulation formula was written dw_3.object.com pute_2 [I] expression=gs, why the second sentence will report the Error accessing external object property compute_2 this Error message? Please expert advice,,,,

CodePudding user response:

Dw_3.object.com pute_2 [I] expression=gs
Can't do that

CodePudding user response:

Dw_3.object.com pute_2. Expression="if (getrow ()=2, gs +" + ", ")"

CodePudding user response:

Expression is assigned to the computational domain, instead of each line, so can't dw_3.object.com pute_2 [I] expression=gs

CodePudding user response:

Expression is well matched, do not need each line to assign the value
Dw_1. Setredraw (false)
Dw_1. Modify (" compute_1 Expression='a + b ")
Dw_1. Setredraw (true)

CodePudding user response:

By the top

CodePudding user response:

The formula for column,

In this column are all the same formula, just we add condition limit,