Table Reporting Tool Currency Question

[Bren312]

Hi everyone, I'm trying to use the Table reporting tool to show Region profits and highlight any negative values.  I'm hoping to show the negative values as Currency in a ($123,456.78) format but I'm not having much luck using the "$" prefix; the negative values are displayed in a $-123,456.78 format.

Hopefully that makes sense; I've attached a workflow with what I've currently got and a screenshot of what I'm hoping to accomplishment.  Also, I'm on version 2019.2.  Thanks everyone!

Bren

[jamielaird]

You can accept multiple solutions btw

[jamielaird]

Haha sorry that may have caused some confusion.. I was more mentioning it in case you wanted to also accept @apathetichell's solution as well, as he deserves a bit of recognition 🙂

[apathetichell]

All good - I just love learning these little program intricacies.

[jamielaird]

I'm not sure anyone loves the Reporting Tools.... would definitely be my #1 area to improve if I was an Alteryx PM!