I have measures that can be either positive or negative.
The end user wants to see the negative values in parentheses and with a dollar sign. I used Currency format but it appends two zeros after the decimal. The user wants to see only the whole number and not the decimal part. Therefore, selecting Currency does not solve the problem. What format string would be suitable in this scenario?