topic Re: How to parse a formula / comparison from a column and apply on other column in Discussions

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

HSS — Thu, 08 Jun 2023 16:42:03 GMT

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.

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

jthi — Sat, 21 Jan 2023 20:21:34 GMT

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 column

HSS — Sat, 21 Jan 2023 20:34:40 GMT

Yes it worked. Thanks Jarmo