Is the SIGN function available to use in Alteryx?
I've tried searching for it but no luck.
Ah shoot, this was for Trifacta. Here's the workaround: Solved: Detection of Positive and Negative Amount - Alteryx Community
@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)))
Is this not it? SIGN Function (alteryx.com)
It's not popping up in the formula tool.
Cool Formula to mirror the Sign function:
([Number]<0) - ([Number]>0)
^suggested by ChatGPT
