- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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.
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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))
-Jarmo
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
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))
-Jarmo
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to parse a formula / comparison from a column and apply on other column
Yes it worked. Thanks Jarmo