591910_en-US

liliconcom

How to parse a formula / comparison from a column and apply on other column

Hi All,
I need to apply formula "Expected values" on my "Results[in%Format]" and store the Yes(1) or No (0) in my results column. I have tried different version of Eval()  and Parse() with no success.

Any help please.

 

 

ScriptingRe: How to parse a formula / comparison from a column and apply on other column

First build a string and then use Eval(Parse())

Eval(Parse(Char(:"Results[in%Format]"n) || :Expected Values))

 

Re: How to parse a formula / comparison from a column and apply on other columnYes it worked. Thanks Jarmo