SIGN Function

[calvincarr29]

Is the SIGN function available to use in Alteryx?

I've tried searching for it but no luck.

[alexnajm]

Is this not it? SIGN Function (alteryx.com)

[alexnajm · Accepted solution]

 Ah shoot, this was for Trifacta. Here's the workaround: Solved: Detection of Positive and Negative Amount - Alteryx Community

[calvincarr29]

It's not popping up in the formula tool.

[CoG]

Cool Formula to mirror the Sign function:

([Number]<0) - ([Number]>0)

^suggested by ChatGPT

[patrick_digan · Accepted solution]

@calvincarr29 For what it's worth, @jdunkerley79 built a sign function into the alteryx abacus which is something you can add in to designer.

I've installed the abacus in my designer, so I can use the sign function: 

Looking under the hood of the abacus functions, James is using this formula:

IIF(ISNULL(Field1),NULL(),IIF(Field1=0,0,IIF(Field1<0,-1,1)))