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

Question

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.

Sample_Data.jmp

jthi · Accepted Answer

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

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