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

[#1]

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.

HSS_0-1674330936955.png

[#2 · Accepted solution]

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

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

jthi_0-1674332472261.png

[#3]

Yes it worked. Thanks Jarmo