This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Does anyone know of a way (in the Reporting Tools) to show negative numbers in parentheses instead of with a "minus" sign in front of them? I know that I can convert them to strings, blah blah blah, formula tool blah blah. I was wondering if there was just a way to change how they are displayed with an option or button click instead of writing formulas.
This is kind of a metaphor for my whole career existence. Being a BI analyst, I have to translate between IT and Operations. IT sees it as a decoration, a mask on the true value of the data, Operations wants uniformity; it must always be "$ (10)", not "-10". While this is a minor inconvenience, it makes any financial reporting in Alteryx a bit tedious.
The closest I can get you with reporting tool clicks is '$(-10)', but not '$(10)'. Sounds like you are tired of writing the same formula repetitively, and the function to get it exactly as you need it can't be configured in the reporting tools. Have you considered building a macro to do this quickly for you? Attached, I built a quick sample macro that shows allow a user to select all numeric fields to convert to your negative number format and output them as a new field you can use for your reporting.
I'm looking at the macro and when it does the conversion from '-1,234' to '$(1234)', it loses the comma. I definitely have to keep the commas in the figures. Is there a way to retain those? Thanks again for the help, it is much appreciated.