Hey @Kinetic_analytics, in order to achieve this result you'll need to sacrifice the numeric data type as you can't have this display without creating a string. To actually get to this format you'll want to use something along the following lines where you check that the value is negative and if so, strip away the - sign and bracket the value:
@Kinetic_analytics as with most things in Alteryx, there's a bunch of ways you could tackle this. As for adding extra tools etc, I don't think that makes sense as it can be handled more than fine within the Formula tool itself. However, here's a few ways using various different string functions that lead to the same outcome:
Of course, all of these could also be turned into immediate if (IIF) statements, taking the form of IIF(Condition, Outcome_if_true, Outcome_if_false), instead of writing them in the standard way as I have. I find writing them out in full tends to be more reader/user-friendly.
