Display number has negative instead of in parentheses using currency format

[thomas_coltrain]

Hey,

I am sure this is an easy one but I can not figure out how to get numbers to display using a negative symbol instead of parentheses using the currency format.  I am using a measure to get a number and sometimes the answer is negative, then I get the answer in parentheses and I need it to be displayed like -$111 or $-111.

Thanks!

[tackytechtom · Accepted solution]

Hi @thomas_coltrain ,

This seems to be the standard (accounting) way to display numbers.

I got a minus sign  with "$ Enlgish (Puerto Rico)" (select the measure in the fields pane on the right and click on the arrow directing downwards next to the Dollar sign in Formatting under Measure Tools ribbon):

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[thomas_coltrain]

Worked like a charm 🙂
Thanks!!!!