Translating Numeric Results with CR9 1

[mjm19]

Have used the following in CR8 to capture specific results.

if NumericText (Left ({Result_View}, 1)) then
ToNumber (ExtractString ({Result_View}. "",",")) else 0

I'm trying to get all results >300 for a particular test using CR9. If the result is = >5000, CR9 does not pick it up using this formula. A result of 5000 is OK, it's the ">" sign that is causing the problem. Any ideas as to how I can pick up those results with the prefix of ">" ?

Thanks in advance

 

[lbass]

Do you have a typo in your formula? Try something like:

if NumericText (Left ({Result_View}, 1)) then
ToNumber (ExtractString ({Result_View},".",",")) else
if left({Result_View}, 1) = ">" and
NumericText(mid({Result_View}, 2, 1)) then
tonumber(ExtractString ({Result_View},".",",")) else 0

-LB