cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
HSS
HSS
Level IV

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.

 

HSS_0-1674330936955.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
jthi
Super User

Re: 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))

jthi_0-1674332472261.png

 

-Jarmo

View solution in original post

2 REPLIES 2
jthi
Super User

Re: 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))

jthi_0-1674332472261.png

 

-Jarmo
HSS
HSS
Level IV

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

Yes it worked. Thanks Jarmo