Multi-Row Formula tool - ABS

[Kinetic_analytics]

Hello:

Good morning folks. I am using Multi-Row Formula tool .

IF( [ hedged]>"500000")THEN "Hedge" ELSE "" ENDIF

How can I address the absolute value (+-500,000) in the formula. 

Appreciate your help.

Thanks

[DataNath · Accepted solution]

@Kinetic_analytics given that you have 500000 in quotes, I'm guessing this [ hedged] field is a string? If so, you'll want to use the following expression:

IF( abs(tonumber([ hedged]))>500000)THEN "Hedge" ELSE "" ENDIF

If [ hedged] is actually numeric then just use:

IF( abs([ hedged])>500000)THEN "Hedge" ELSE "" ENDIF

On another note: It doesn't look like you're referencing previous or following rows - unless this is part of a larger expression, you should just be able to use a regular Formula rather than Multi-Row.

[Kinetic_analytics]

Thank you. Appreciate your help all the time my friend. :) Have a great day. I learned a lot from you.